Restore 7.0 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore 7.0

Author

Topic

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-07 : 15:49:08

Can you do a restore in 7.0 like 2000, where if the db doesn't exist, it will create it for you..or do have create on first?

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-07 : 16:03:54

You do not have to create the database first. If the database exists, you need to specify WITH REPLACE in the RESTORE command. This applies for both SQL 7 and SQL2k. I always put WITH REPLACE in the RESTORE command just out of habit.

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-07 : 16:06:34

Houston, we have a problem


Server: Msg 3120, Level 16, State 1, Line 1
The database you are attempting to restore was backed up under a different sort order ID (52) than the one currently running on this server (53), and at least one of them is a non-binary sort order.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

What's the out of the box sort order for 7? 52 or 53?

And WHY anyone in the states would not choose the out of the box config is beyond me.

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-07 : 16:13:16

52 is the default.

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-07 : 16:17:49

And since they layed everyone off...there's no one left in HR to blame...

Time to rebuild the box....

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources