Backup

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

With RESTORE DATABASE. 🙂

You can fire that from the GUI in SSMS if you're not familiar with the T-SQL syntax.

On the object explorer right click the "Databases" node and select "Restore Database".

Fill the form and click OK.

SQL Server is backward-compatible, that means you can restore a SQL2005 backup on a SQL2008 instance, but you can't do the opposite.

Hope this helps.

Gianluca

-- Gianluca Sartori

Shafat Husain SSCrazy Points: 2754 More actions · Answer 2

Restore Database [Database Name]

from Disk='[backup location]'

with move '[logical data file name]' to '[path to store mdf file]',

move '[logical log file name]' to '[path to store ldf file]'

to find out the logical name of data and log file you can use

Restore filelistonly from disk='[backup location]'

Eg.

Restore Database Test

from Disk='D:\backup\test.bak'

with move 'Test_dat' to 'D:\Data\Test.mdf',

move 'Test_log' to 'D:\Data\Test_1.ldf'

Regards

Shafat Husain

Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)

sudesh 2923 Newbie Points: 9 More actions · Answer 3

Both reply are very help full i want more