Developer Scripts: Restore Data Base

Showing posts with label Restore Data Base. Show all posts

Tuesday, March 20, 2012

Restore Data Base SQL Server

RESTORE DATABASE [PointOfSale] 
FROM  DISK = N'C:\MyDataFiles\PointOfSale_Full.bak' 
WITH  FILE = 1,  
MOVE N'PointOfSale_Data' TO N'C:\MyDataFiles\PointOfSale_Data.mdf',  
MOVE N'PointOfSale_Log' TO N'C:\MYDataFiles\PointOfSale_Log.ldf',  
NOUNLOAD,  STATS = 10

Please visit: www.TyroDeveloper
Please Click on +1