Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server.
Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
Wednesday, February 23, 2011
Restore DB
RESTORE DATABASE [dbName] FROM DISK = N'D:\temp\dbName_backup_2011_02_23_020006_4755253.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10 GO
No comments:
Post a Comment