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
 how to restore DB ???

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.
Go to Top of Page

suresha_b
Yak Posting Veteran

82 Posts

Posted - 2008-05-22 : 10:00:04
RESTORE DATABASE DatabaseName
FROM DISK = 'BackupFileName.BAK'
Go to Top of Page

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 DB

USE [master]
GO
RESTORE DATABASE DB_NAME
FROM DISK= 'D:\DB_NAME.Bak'
Go to Top of Page
   

- Advertisement -