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.
Author |
Topic |
SanjaySutar
Starting Member
18 Posts |
Posted - 2008-05-22 : 09:24:25
|
Hi i have a sql server 2000 DB backup.I want to restore it in a DB where the DB is not already present ????how can i do that ????San |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-22 : 09:26:07
|
Check restore command in Books Online. |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-05-22 : 10:00:04
|
RESTORE DATABASE DatabaseNameFROM DISK = 'BackupFileName.BAK' |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2008-05-22 : 10:02:57
|
quote: Originally posted by SanjaySutar Hi i have a sql server 2000 DB backup.I want to restore it in a DB where the DB is not already present ????how can i do that ????San
from a location you can restore your DBUSE [master]GORESTORE DATABASE DB_NAME FROM DISK= 'D:\DB_NAME.Bak' |
|
|
|
|
|