Activity overview
Latest activity by pcorujo
No it's not restoring any tlogs. Is there anyway around the checkpoint? The restores are fine but the jobs always appears to fail so the alerts go out. / comments
No it's not restoring any tlogs. Is there anyway around the checkpoint? The restores are fine but the jobs always appears to fail so the alerts go out.
Error: 18272, Severity: 16, State: 1
Hi All,
I have a job which backups up databases and copies them to another server. There they are restored and upgraded from 2005 to 2008. The restores succeed but i get the following error:
Erro...
Log shipping
HI All,
I am setting up log shipping from SQL 2005 to SQL 2008 in order to migrate from a stand alone server on 2005 to a cluster on 2008 R2.
When I setup log shipping through the SSMS GUI records ...
SQL Backup Log shipping
HI All,
I am setting up log shipping from SQL 2005 to SQL 2008 in order to migrate from a stand alone server on 2005 to a cluster on 2008 R2.
When I setup log shipping through the SSMS GUI records ...
Thank you sir, thats perfect. / comments
Thank you sir, thats perfect.
Automated DB Restore Based on SQL Backup FileName
Hi All,
I am backing up a database, and using the copy option to move it to another server. I then need to automate the restore of that backup on the new server. The backup naming convention is s...
Thanks again, I truly appreciate your help. / comments
Thanks again, I truly appreciate your help.
Thank you for you response. We do not have anything backing up to tape so i would imagine that the flag would reflect that we have not archived. So would that mean the archive flag would be unset? / comments
Thank you for you response. We do not have anything backing up to tape so i would imagine that the flag would reflect that we have not archived. So would that mean the archive flag would be unset?
Delete backup issue
Hi,
I am trying to take backups locally as well as copy them to another box and then delete backups older than 2 days on both servers. My current code pasted below does take and copy the backups b...