Create from a backup? - 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

General SQL Server Forums

New to SQL Server Programming

Create from a backup?

Author

Topic

JVRudnick
Starting Member

4 Posts

Posted - 2005-08-26 : 16:23:22

how do you create a new SQL2000 dbase from a backup only?

can someone point me here?

Herb

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-08-26 : 16:29:46

BACKUP DATABASE DBNameGoesHere
TO DISK = 'C:\SomeBackupFile.BAK'

RESTORE DATABASE NewDBName
FROM DISK = 'C:\SomeBackupFile.BAK'
WITH REPLACE, MOVE...(check RESTORE DATABASE in SQL Server Books Online for the specific syntax)

Tara

Kristen
Test

22859 Posts

Posted - 2005-08-27 : 01:43:40

JVRudnick: I provided a full example of the syntax a few days ago, if you need it:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources