Any good DR guides on recovering SQL

Are there any good Disaster Recovery guides( playbook) on prepping up for DR
as it pertains to SQL along with what to do when a disaster does
occure..i.e. recovery section.
I am trying to prepare it for our SQL environment in our organization and
would love to get a template that I can use along with scripts probably that
can capture all the relevant info about the SQL Server such as dbs, logins,
jobs and their schedules, SSIS/DTS packages,replication if any,etc..There are ton's of scripts related to disaster recovery @.
<http://www.sqlcommunity.com/SQLAutomation/tabid/56/Default.aspx> SQL
Automation section. If you can't find what you are looking for then you may
request one.
--
Thank you,
<WWW.SQLCOMMUNITY.COM> (World Wide Community for SQL Server Professionals)
SQLTips, SQL Automation Scripts, SQL Articles, SQL Blogs, SQL Events, SQL
Forums, etc
"Hassan" wrote:
> Are there any good Disaster Recovery guides( playbook) on prepping up for DR
> as it pertains to SQL along with what to do when a disaster does
> occure..i.e. recovery section.
> I am trying to prepare it for our SQL environment in our organization and
> would love to get a template that I can use along with scripts probably that
> can capture all the relevant info about the SQL Server such as dbs, logins,
> jobs and their schedules, SSIS/DTS packages,replication if any,etc..
>
>|||How do you download the scripts ? Do i need to register first ?
"SQL Server Community Announcement"
<SQLServerCommunityAnnouncement@.discussions.microsoft.com> wrote in message
news:8500BAB1-892B-4ED8-9854-2DE46A0D7E7D@.microsoft.com...
> There are ton's of scripts related to disaster recovery @.
> <http://www.sqlcommunity.com/SQLAutomation/tabid/56/Default.aspx> SQL
> Automation section. If you can't find what you are looking for then you
> may
> request one.
> --
> Thank you,
> <WWW.SQLCOMMUNITY.COM> (World Wide Community for SQL Server Professionals)
> SQLTips, SQL Automation Scripts, SQL Articles, SQL Blogs, SQL Events, SQL
> Forums, etc
>
> "Hassan" wrote:
>> Are there any good Disaster Recovery guides( playbook) on prepping up for
>> DR
>> as it pertains to SQL along with what to do when a disaster does
>> occure..i.e. recovery section.
>> I am trying to prepare it for our SQL environment in our organization and
>> would love to get a template that I can use along with scripts probably
>> that
>> can capture all the relevant info about the SQL Server such as dbs,
>> logins,
>> jobs and their schedules, SSIS/DTS packages,replication if any,etc..
>>|||Yes Hasan, you'll have to register on the wesite first to be able to download
the script. (Registration is free and quick)
--
Thank you,
HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
Server Fun.
"Hassan" wrote:
> How do you download the scripts ? Do i need to register first ?
> "SQL Server Community Announcement"
> <SQLServerCommunityAnnouncement@.discussions.microsoft.com> wrote in message
> news:8500BAB1-892B-4ED8-9854-2DE46A0D7E7D@.microsoft.com...
> > There are ton's of scripts related to disaster recovery @.
> > <http://www.sqlcommunity.com/SQLAutomation/tabid/56/Default.aspx> SQL
> > Automation section. If you can't find what you are looking for then you
> > may
> > request one.
> >
> > --
> > Thank you,
> > <WWW.SQLCOMMUNITY.COM> (World Wide Community for SQL Server Professionals)
> > SQLTips, SQL Automation Scripts, SQL Articles, SQL Blogs, SQL Events, SQL
> > Forums, etc
> >
> >
> > "Hassan" wrote:
> >
> >> Are there any good Disaster Recovery guides( playbook) on prepping up for
> >> DR
> >> as it pertains to SQL along with what to do when a disaster does
> >> occure..i.e. recovery section.
> >>
> >> I am trying to prepare it for our SQL environment in our organization and
> >> would love to get a template that I can use along with scripts probably
> >> that
> >> can capture all the relevant info about the SQL Server such as dbs,
> >> logins,
> >> jobs and their schedules, SSIS/DTS packages,replication if any,etc..
> >>
> >>
> >>
>
>|||I am also writing a series of blog entries on this but pertains to SQL
Server 2005 - some techniques can also be applied to SQL Server 2000
http://bassplayerdoc.blogspot.com
"Saleem Hakani" <SaleemHakani@.discussions.microsoft.com> wrote in message
news:56BA8262-0959-4636-8A55-2459659B5C0D@.microsoft.com...
> Yes Hasan, you'll have to register on the wesite first to be able to
> download
> the script. (Registration is free and quick)
> --
> Thank you,
> HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
> SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
> Server Fun.
>
> "Hassan" wrote:
>> How do you download the scripts ? Do i need to register first ?
>> "SQL Server Community Announcement"
>> <SQLServerCommunityAnnouncement@.discussions.microsoft.com> wrote in
>> message
>> news:8500BAB1-892B-4ED8-9854-2DE46A0D7E7D@.microsoft.com...
>> > There are ton's of scripts related to disaster recovery @.
>> > <http://www.sqlcommunity.com/SQLAutomation/tabid/56/Default.aspx> SQL
>> > Automation section. If you can't find what you are looking for then you
>> > may
>> > request one.
>> >
>> > --
>> > Thank you,
>> > <WWW.SQLCOMMUNITY.COM> (World Wide Community for SQL Server
>> > Professionals)
>> > SQLTips, SQL Automation Scripts, SQL Articles, SQL Blogs, SQL Events,
>> > SQL
>> > Forums, etc
>> >
>> >
>> > "Hassan" wrote:
>> >
>> >> Are there any good Disaster Recovery guides( playbook) on prepping up
>> >> for
>> >> DR
>> >> as it pertains to SQL along with what to do when a disaster does
>> >> occure..i.e. recovery section.
>> >>
>> >> I am trying to prepare it for our SQL environment in our organization
>> >> and
>> >> would love to get a template that I can use along with scripts
>> >> probably
>> >> that
>> >> can capture all the relevant info about the SQL Server such as dbs,
>> >> logins,
>> >> jobs and their schedules, SSIS/DTS packages,replication if any,etc..
>> >>
>> >>
>> >>
>>