SQL Server problem!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » SQL Server problem!

SQL Server problem!

Rate Topic

Display Mode

Topic Options

Author

Message

nicholas-250056

Posted Wednesday, August 03, 2005 12:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 20, 2005 5:23 PM
Points: 5, Visits: 1

Good day, my name is nicholas, a newbie of SQL Server 2000, currently, got a question to ask, please kindly help!

Currently, i already created 87 tables in SQL Server 2000 Developer Edition (in my PC), then, can i know is there any method to "copy & paste" all these 87 tables or "copy & paste" the whole database to the SQL Server 2000 Standard Edition (in a server)?

i already try the "Generate SQL Script", but since like i am in the wrong steps already~! Thus, please kindly help me, teach me or show me some instructions, MANY THANKS!

best regards,
Nicholas

Post #206704

Jason Hall

Posted Wednesday, August 03, 2005 7:15 AM

Old Hand

Group: General Forum Members
Last Login: Friday, April 29, 2011 1:09 PM
Points: 392, Visits: 81

The best method for this is to take a backup of your development database and restore the backup file into production.

Post #206842

SQLBill

Posted Wednesday, August 03, 2005 7:35 AM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 10:47 AM
Points: 3,226, Visits: 424

another method is to detach the database, copy the .mdf and .ldf files to their new location and then attach them.

-SQLBill

Post #206858

nicholas-250056

Posted Wednesday, August 03, 2005 4:56 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 20, 2005 5:23 PM
Points: 5, Visits: 1

are u means right click the database, select "All Task" -> then "Back up Database?

is it means that if i can find the .mdb & .ldf together, then wht u means of "ATTACH" them?

Thanks for ur help~!

Post #207137

sushila

Posted Wednesday, August 03, 2005 9:08 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:52 AM
Points: 2,553, Visits: 515

Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either

at any rate - jason hall's method:

click on the wizard icon (the magic wand) on the tool bar of enterprise manager, go to "management" - "backup wizard" - it'll walk you through all the steps - copy the backup file which will be saved with a .bak extension in your backup folder - save it in a folder in your target server - create a brand new database in the target server - - and right click - select "all tasks" - "restore database" - "from device" - "select devices" - "add" - navigate to saved .bak file and open - say "ok"

sqlbill's is to right click - select "all tasks" - detach database - go to the data folder which will have saved your data and log files with an .mdf and .ldf extension - copy these files - and then "attach" them in the target server. However, if you're new to all this - my suggestion would be to do it Jason's way - it's easier to follow!

A third way - if you have only created the tables but not populated it with any data - is to right click on one of the tables - select "all tasks" - "generate sql script" - "show all" - and under the options tab - select either "create one file" or "create one file per object" - then you can copy this/these file/s and run the script in the query analyzer (after having created a new database in the target server).

Use BOL (books on line) for help and guidance regardless of the method you choose. Everything seems difficult when it is new but with practice you'll be surpised how easy and effortless it all becomes. Good luck!

**ASCII stupid question, get a stupid ANSI !!!**

Post #207176

CJohnson-232084

Posted Thursday, August 04, 2005 7:09 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 5:17 AM
Points: 104, Visits: 3

THANK YOU SUSHILA!!!

>>Rats - I just spent the last half an hour typing out the various steps - only to have the whole text "vanish" - ctrl z isn't bringing it back to life either <<

I have had this happen several times and have yet to figure out why. I've taken to saving my reply in Notepad before clicking "Post Reply" or "Preview." This is an irritation, but not as bad as losing several minutes of work (and carefully crafted brilliance ).

Post #207323

sushila

Posted Thursday, August 04, 2005 7:25 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:52 AM
Points: 2,553, Visits: 515

I keep meaning to do this (type response in Notepad) but suffer from memory lapses everytime!

I'm not sure why I'm being thanked - is it because I confirmed for you the fact that you needn't have been rubbing your eyes out off your head everytime your (carefully crafted brilliance) turns out to be apparitional ?!?!?!

**ASCII stupid question, get a stupid ANSI !!!**

Post #207334

CJohnson-232084

Posted Thursday, August 04, 2005 8:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 5:17 AM
Points: 104, Visits: 3

I thank you for confirming the event. I thought I was just experiencing premature 'old timers' disease and losing my way around the form. This is an inconsistent, irritating, recurring problem. I would love to take the time to figure out what is going on, but as we all know, time is in short supply in our field these days. Hence the long diatribe and the continued popularity of this forum!

I love your refreshing use of 'apparitional.' Proficiency in and appreciation of grammar, syntax, and non-technical vocabulary is somewhat rare in IT.

Happy days.

Post #207365

« Prev Topic | Next Topic »

Permissions