Skip to main content

Backup and Restore Database Commands

 BACKUP DATABASE [DB_Name]

       TO DISK = N'\\server\directory\backupfile.bak'

       WITH NOFORMAT, INIT, NAME=N'DBNAME', SKIP,    NOREWIND, NOUNLOAD, STATS=10;

 

RESTORE FILELISTONLY

              FROM DISK= N'\\server\directory\backupfile.bak'

 

DROP DATABASE [DB_Name] ;

 

RESTORE DATABASE [DB_Name]   

       FROM DISK=''\\server\directory\backupfile.bak'

       WITH

       MOVE 'DB_logicalName' TO

              'D:\Databases\data file name.mdf',

       MOVE 'DB_Log Name_log' TO       

              'E:\Logs\log file name_log.ldf'

 

 

Comments

Post a Comment

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more