Home > shell > How To Restore A SQL Server Database via SQLCMD

How To Restore A SQL Server Database via SQLCMD

November 11th, 2009 Leave a comment Go to comments

Run this with SQLCMD to restore a SQL Server database:

RESTORE DATABASE MyDatabase
FROM DISK = 'd:\backup\MyDatabase.bak'

It’s that simple.
Thanks to Michael Otey @ SQL Server Magazine.

Tags:
  1. No comments yet.
  1. No trackbacks yet.

 
Performance Optimization WordPress Plugins by W3 EDGE