Wednesday, March 7, 2012

Data BackUp and Restore

hi,

pls tell me any step by step tutorial (with graphic presentation) to restore and backup the database on sql server 2005.


thank you.

The example below uses both theBACKUPandRESTORE statementsto make a copyof the Northwinddatabase.
The MOVE statement causes the dataandlogfile to be restoredto the specified locations.
TheRESTORE FILELISTONLY statementis usedto determine the numberand namesof the filesin thedatabase being restored.
The new copyof thedatabase is named TestDB.For more information, seeRESTORE FILELISTONLY.BACKUP DATABASE NorthwindTO DISK ='c:\Northwind.bak'RESTORE FILELISTONLYFROM DISK ='c:\Northwind.bak'RESTORE DATABASE TestDBFROM DISK ='c:\Northwind.bak'WITH MOVE'Northwind'TO'c:\test\testdb.mdf', MOVE'Northwind_log'TO'c:\test\testdb.ldf'GO

No comments:

Post a Comment