Foxhole Atheist
Wednesday, December 25, 2013
Simple copy dtabase script in sql server 2005
BACKUP DATABASE blah
TO DISK = 'd:\blah.bak'
RESTORE DATABASE blah_blah
FROM DISK = 'd:\blah.bak'
WITH MOVE 'blah' TO 'd:\databases\blah_blah.mdf',
MOVE 'blah_log' TO 'd:\databases\blah_blah.ldf'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment