Suppose I want to backup a database with following policy: 1. Full backup weekly 2. Incremental backup daily 3. transaction log backup hourly then create maintenance plan for above policy and the ...
I'm working with SQL Server 2008Sp3. I have a database that was restored from a full backup WITH NO RECOVERY and it then was restored with Transaction log backup files - also WITH NO RECOVERY. At ...
A couple of days ago I was testing some stuff using the Maintenance Plans in SQL Server 2008. I created one to rebuild indexes and take a full backup every week. (I know, bad thing I've found out ...