Posts
Sort by recent activity
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...
back up all system databases
:?:
is there a way to back up all the system databases via 1 script line like you can do single databases? Or do I have to do each system database seperately as in the script?
Delete files older than xxx
I have a SQL job that is running the follwing T-SQL statement. However when it is run it is not deleting the prior day(s) files. Is it because I am doing an <Auto> on the name?
EXECUTE master.....
Backup extended stored procedure
when using this stored procedure does it automatically assume replace the existing file or is there a parmater that I need to qualify?
:?: