March 10, 2013 at 11:01 pm
what are the best practices for the backup plan.
March 10, 2013 at 11:20 pm
Best practice is to backup your database and transaction log as required by recovery objectives put forth by the business.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2013 at 11:26 pm
I want to know the steps before we take backup based on recovery objective.
like first integrity checks .. so that we are taking the uncorrupted databases backups . then backups are taken. then backups are verified and then index maintenance like wise. which order we have to follow.
March 10, 2013 at 11:32 pm
Run backups with checksum
Perform Regular Checkdb (you can do that before or after your backup jobs - but it depends on your environment as to when and how you do it)
Index maintenance depends on your environment.
There is no hard and fast rule as to when each task is "supposed" to be run. It is greatly dependent on your environment and the business needs and requirements.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2013 at 11:37 pm
Thanks for your valuable suggestion.
i have one more question.. when i checked disks using xp_fixeddrives it showed C and E drives. recently our backup job failed so i went to backup plan and find the path .. I found that backups are going to Z drive.. what does this mean.. how to take backups other than fixed drives.
March 10, 2013 at 11:48 pm
You can take a backup to a UNC path \\server\share
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2013 at 11:54 pm
but in maintenance plan dialogue box it shows like local disk button is selected and in path just Z drive is showing with out showing any network shared path
March 10, 2013 at 11:59 pm
I'd convert from maintenance plan backups and use script based backups.
But, even in the maintenance plan, you can type out the path for a UNC rather than rely on what that button will display as possible backup paths for you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply