Recently had to re-install all of pc...not a prob as all (except db) was backed up to seperate hd. I develop locally using MSSQL client tools and adp's and then upload new tables as and when ready. I had done quite a bit of work when pc died, and now have to recreate half a dozen tables plus repopulate data.
Can I make a 'create table' sql code which I can then run to restore tables, or is there another way?
Thanks in advance.
Shalinko
0
Newbie Poster
Recommended Answers
Jump to PostHi,
There are 2 ways, detach, backup, and attach. Or generate Script.
First the first one you will need to right click database and in all tasks sub menu choose detach database. Now go to the C:\Program Files\Microsoft SQL Server\MSSQL$\Data\ and look for the data base name. You will …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.