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'
Labels:

Comments

Post a Comment

Popular posts from this blog

Turn off AutoPlay on Windows

On Windows, when you insert an USB or a CD/DVD into your computer, they are usually opened automatically. So the computer maybe infected autorun virus. To avoid that, you should turn off AutoPlay function.
Post a Comment
Read more

Install and play Pokemon Go on unsupported device

Pokemon Go is great mobile game for smart devices (Android, iOS...). Many people can install and play it normally. However, some device has not been supported yet (Intel inside smartphone: Asus Zenfone, Dell Veune, ...; Windows Phone devices...). Here we show you how to play it in all your devices. For Android devices: Enable “Unknown sources” in the settings. Download Pokemon Go app setup:  Link 1  / Link 2   Open the downloaded file to install app. Enable all the settings when promted. Now you can open and run Pokemon Go to catch 'em. ... That's all. Wish succeed!
Post a Comment
Read more