Mssql Notes

From Federal Burro of Information
Jump to navigationJump to search

Coomand line

sqlcmd
use <databasename>
create database meme

restore:

USE meme;  
RESTORE HEADERONLY   
FROM DISK = N'C:\AdventureWorks2012-FullBackup.bak' ;  
GO