October 21, 2008 at 5:25 am
can anyone advise how to restore a database to a different database on the same server using sql server 2005
As one of my tables is corrupted and i would like to restore from backup from last week.
October 21, 2008 at 6:54 am
follow the restore gui and in the restore to database type the new database name. select from device and browse for the backup rest is straight forward
or T-SQL
RESTORE DATABASE mine FROM DISK = 'e:\folder\path.bak'
WITH MOVE 'datalogicalname' TO 'D:\folder\pathame.mdf',
MOVE 'loglogicalname' TO 'D:\folder\pathame.ldf'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2008 at 3:17 am
Thanks perry thats exactly what i needed.
cheers,
iain.
October 22, 2008 at 7:11 am
your welcome m8tey 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply