T-sql restore db SqlServer

RIpristinare un db tramite t-sql



RESTORE FILELISTONLY
FROM DISK = 'D:\wvoce_sin2010\dbwvoce.bak'
GO


----Make Database to single user Mode



ALTER DATABASE db-name
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE

----Restore Database
RESTORE DATABASE db-name
FROM DISK = 'D:\file.bak'
WITH REPLACE,MOVE 'filem-df' TO 'D:\file.bak',
MOVE 'file-log' TO 'C:\file.ldf'

ALTER DATABASE pentaho SET MULTI_USER
GO