Activity overview
Latest activity by dwjongbloed
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 ...
thanks for the reply Petey. I like the fact that Restores support search/wildcards but now here's another potential issue. Everyday I am restoring the "FULL" back up of the database(s). I only want to restore the logs after the given Full back up time for the given day. Any Ideas on how to do this?
I am thinking that this is going to be more difficult than I want it to be and will just end up writing instructions to do it in the GUI screen as I am needing this in case we have a disaster and I am not around / comments
thanks for the reply Petey. I like the fact that Restores support search/wildcards but now here's another potential issue. Everyday I am restoring the "FULL" back up of the database(s). I only ...
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...