Menu
How can I restore a live database without taking its backup first?
We can do this from SQL Server Management Studio, but I want to do this with script, which i can run as a scheduled job.
649
Backup and restore SQL database from one server to anotherLaunch SQL Server Management Studio and connect to the instance you want to backup. Then right-click the specific database, choose Tasks > Back Up. 2. Make sure the backup type is full backup, and then select a destination.
Choose restore source - another DB. To generate a SQL script - press the button
127
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
