Saturday, March 9, 2013

[MS SQL Server] Possible to use Policies to force ad-hoc backups to be copy_only?

[MS SQL Server] Possible to use Policies to force ad-hoc backups to be copy_only?

Possible to use Policies to force ad-hoc backups to be copy_only?

Posted: 08 Mar 2013 05:14 AM PST

So at my new employer, the backup schedule is weekly fulls, daily differentials, and bi-hourly transaction logs.We need to fairly often (couple times a week or so) take backups of production DBs and restore them to QA. Having read [url=http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/]this blog posting[/url] from another topic on this here, I can see we should do copy_only so as to not break the differential sequence.I took a brief look into Management Policies, and to be honest, I'm thinking the answer to this is going to be that we can't enforce this, we'll have to make sure to do it ourselves.But it doesn't hurt to ask...:-DThanks,Jason A.

What is the Difference between 32bit replication and 64bit replication?

Posted: 08 Mar 2013 05:44 AM PST

Hi Friends,What is the Difference between 32bit replication and 64bit replication?Thanks in Advance. :-)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog