Tag Info

New answers tagged

1

You can automate all of below using SQL Agent. There are many alternatives that you can use : SQLCMD ==> sqlcmd -E -S server_name -q "backup command" You can use it with dynamic sql to connect to different servers for backup and restores. PowerShell ==> There are tons of scripts found on internet that will tell you how to do it. SimpleTalk has -- Backup ...


2

I read that the change in recovery model only has effect after a backup is taken. However, if after the performing the above I do This is mainly for when you change from simple recovery to full. After changing from simple to full you need to take full backup to take database out of Pseudo simple recovery. Pseudo simple recovery means even if database is ...


1

To ensure there are no migrations in progress while taking your backup, you should stop the balancer via sh.stopBalancer(). Any in-progress migrations will be completed before the balancer is disabled. If you want to ensure the balancer is stopped before taking your backup, you can run the following in the mongo shell, which should return true: ...


2

Carlo, do you have other ideas? You jus took a backup, so when you write the execute SQL Statement part of your job reference the MSDB backup history information tables to pull out the latest full and any other diffs/logs/etc that you would like to apply. The data can be found in msdb under the dbo schema and will give you the file names, etc, so there ...


0

If the tables were dropped, ApexSQL Recover can recover them even from databases in the simple recovery model. ApexSQL Recover can recover both table structure and table records On the other hand, ApexSQL Log cannot recover records lost when a table was dropped, it can only recover the table structure In case the records that were lost using DELETE (not ...


0

It was an issues on the hard drive. It never showed any errors in event viewer or the controller. When we rebooted the server, the errors showed up and we replaced the drives.



Top 50 recent answers are included