Posts
Sort by recent activity
copyto questions
Just wondering if you can use the copyto function to copy to a USB external drive rather than another server? Some of the sites that I have have slow wan connections so it would take a while for t...
SQL Server agent restore job fails - manual restore works
I have been trying to get one of my SQL Server agent jobs to restore a database and it keep failing on me. If I restore the database manual via the RedGate software on the GUI screen it works just...
Restore Logs error
I have a job that restores a Full backup at 2:30 am. The Full backup is taken at 12:30 am. The restore leaves the database to where I can restore the logs if needed. However when I try to go a...
Error when restoring DB
I'm working on documentation to allow a non-SQL user to be able to do a restore in my absence. I've had them create the connection with SQL Server authentication w/ user id of SA. However when we...
Restore master,model,msdb
Looking for instructions on how to restore the master, model, msdb databases.
Restore - GUI not showing mapped drives
Hi - I am trying to write some documentation on how to do restores for some users in my company and I have a mapped drive out to our NETAPP where our backups reside at. However when I go into the ...
Script log backups
I have an interesting question. I am wanting to come up with someway to back up my T-logs so I can run a script on my DR server to restore them. I have this running for my full backups but my log...
scripting restore job
I am trying to script a restore job on my Disaster recovery server and have the script just about done but am running into a snag. When I check the syntax on it I get this error:Msg 170, Level 1...
options for naming backup files
Are there other options for auto naming a back up file? I know you can use <AUTO> to have the date and time appended to the end of the file name but I'm looking to have just the date or day of th...
help installing on Cluster
I am relatively new to SQL and RedGate and Clusters. I have installed the base SQL Backup software on the active node(i haven't installed on passive node yet) and am running the SQBServerSetup.ex...