Skip to main content

Backup and restore MS SQL database with SQL query

In Microsoft SQL Server Management Studio, you can backup and restore your database on graphic user interface. But, sometimes, you will see some problems with some database/backup file which isn't on your PC. Then, SQL query maybe useful for you.




  • Backup database to file:


BACKUP DATABASE your_database_name
TO DISK = '\\your_pc_name\shared_folder\your_database_name.bak'


  • Restore database from file:

    • Get old file list in your backup file:




RESTORE FILELISTONLY
FROM DISK = '\\other_pc_name\shared_folder\your_database_name.bak'



    • Restore database with LogicalName from result list



RESTORE DATABASE new_database_name
FROM DISK = '\\other_pc_name\shared_folder\your_database_name.bak'
WITH MOVE 'LogicalName of data' TO 'C:\new_database_name.mdf'
,MOVE 'LogicalName of log' TO 'C:\new_database_name_log.ldf'

Comments

Popular posts from this blog

Fix network printer error 0x0000709

When printing in the network, sometimes you see the error "Operation could not be completed (error 0x00000709). Double click the printer name and make sure that the printer is connected to the network".  Here we show how to fix the error: Open Windows Control Panel Open Credential Manager Choose Windows Credentials Click Add a Windows credential Internet or network address: input the computer name which share the printer User name: input "guest" Password: leave it blank Then click OK and reconnect the shared printer Do not need: uninstall Windows updates; change Windows registry... This maybe applied for error: 0x00000005, 0x0000011b... Watch the step by step video on here: