Mssql Notes

From Federal Burro of Information
Revision as of 20:12, 16 October 2016 by David (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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