I've just been hit with this at work. They're wanting to implement Avamar with the SQL plugin even after it took over a day to backup a test server....

There's plenty of examples on the net for that, eg

http://www.howtogeek.com/131881/how-to-delete-files-older-than-x-days-on-windows/

Since you are creating a mirror database, do not use WITH RECOVERY or you'll have to start again. The mirror needs to remain in an unrecovered state.

You also only...

Restore FULL, latest DIFF, and all transaction log backups for the day, all WITH NORECOVERY. Then create the mirror before the next log backup occurs.

Also, you should be testing...

No, it REBUILDS the indexes (in SQL2005+ terminology). The equivalent of REORGANIZE is DBCC INDEXDEFRAG and this cannot be done with a Maintenance Plan.

Just looked that one up, unfortunately looks like it cannot be changed. You'd need to setup a SQL agent job to copy out the log files to a seperate...

Trigger is probably better, or put into a temp table and roll it all into a single transaction in case of failure.

BEGIN TRAN

--Create new locations and capture Location Name and...

Just untick the max number of error log files so they aren't recycled. Then create a SQL agent task that deletes log files older than 1 year using powershell or...

Just wanted to add that I also encountered this issue today. Also on SQL2008R2 SP1.

Very weird, the error is reported on the publisher but is referring to a failure...

Run

exec msdb.dbo.sp_help_job

In the category column, you should see REPL-QueueReader

You can't add a dependency unless the disk is part of the same resource group, which it's not if it's for another instance.

You need to provision more space or add...

Just check if the job is running the the SQL agent, can be on the subscriber or publisher server.

Or

Right click Replication, Launch Replication Monitor.

Click publication name in the tree,...

Run this

[sys].[sp_helpreplicationdboption]

If there is a 1 in mergepublish field, yes, else no.

You need to have an identitical OS as clustering changed quite a bit between Windows 2003 and 2008. You also cannot upgrade the existing cluster to 2008, it would...

First you need to stop SQL and change the service account to a domain account. Best practise is to use a new account with no privleges (other than Instant...