Littley Computer Services Inc.
Friday, 6 January 2012
Use T-SQL to restore a database
Way quicker than using SQL Server Management Studio, especially if you have to repeat often.
RESTORE DATABASE [Database Name]
FROM DISK 'c:\data\client\project\backupfile.bak'
WITH FILE = 1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment