Activity overview
Latest activity by cfidoe
Sql Backup with Mirrored Server
We have 2 servers set up to be the primary and mirror server..
Is there any way for Sql backup to know which one is which and backup accordingly?
We have a solution set up for the primary which wor...
I found a workaround for this... If anyone is interested..
I changed sql backup to not "auto" name the backup file... It now names it as today.sqb
once it's copied down to the local machine on a folder named "today" - the sql restore runs with the script I created to restore today.sqb in the folder "today".. Then a batch file creates a folder named as the date. the batch file then copies the today.sqb from the "today" folder into this new %date% folder. Then a script runs later to delete the old copy in the today folder. This way the sql restore script can use a static database name but still keep the database up to date with different backups.
This wouldn't really be a problem for anyone (doing the scripts and everything) if they didn't need to keep the backups for a few months back in time like we do.. / comments
I found a workaround for this... If anyone is interested..
I changed sql backup to not "auto" name the backup file... It now names it as today.sqb
once it's copied down to the local machine on a fo...
Schedule SQL RESTORE (not backup)
I read the knowledge base article..
I'm not familiar at all with sql scripts so correct me if I'm wrong here..
Won't the script that is generated when I run through sql backup wizard only backup th...
Thank you - that is what I was afraid of. / comments
Thank you - that is what I was afraid of.
Log Shipping from 2005 to 2008
I finally got a log shipping solution set up, but we are not able to run it in "WITH STANDBY" mode.. Getting an error that says
Process Terminated Unexpectedly. Error Code -2139684860
SQL error 301...
Log Shipping - Network Shares
I'm trying to set up a log shipping solution between a dev server in our domain and a production server hosted at a remote site.
I am able to connect to and contact the remote sql without any probl...