Mssql Notes: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
(Created page with "== Coomand line == sqlcmd use <databasename>") |
No edit summary |
||
| Line 4: | Line 4: | ||
use <databasename> | use <databasename> | ||
create database meme | |||
restore: | |||
USE meme; | |||
RESTORE HEADERONLY | |||
FROM DISK = N'C:\AdventureWorks2012-FullBackup.bak' ; | |||
GO | |||
Latest revision as of 20:12, 16 October 2016
Coomand line
sqlcmd
use <databasename>
create database meme
restore:
USE meme; RESTORE HEADERONLY FROM DISK = N'C:\AdventureWorks2012-FullBackup.bak' ; GO
