any link that talks about different DR options

We want to set up Disaster Recovery for our SQL databases and want to
evaluate the different technologies out there that can do so..( log
shipping, mirroring, stretch clustering, SAN replication, 3rd party,etc.)
and wanted to get a quick overview of the pros and cons of each approach
that may be listed on a link already.
Can someone let me know if there is one out there and send me the path ?
ThanksHi Hassan,
Check these links:
http://technet.microsoft.com/en-us/...r/bb331801.aspx
http://support.microsoft.com/kb/822400
Jonathan
Hassan wrote:
> We want to set up Disaster Recovery for our SQL databases and want to
> evaluate the different technologies out there that can do so..( log
> shipping, mirroring, stretch clustering, SAN replication, 3rd party,etc.)
> and wanted to get a quick overview of the pros and cons of each approach
> that may be listed on a link already.
> Can someone let me know if there is one out there and send me the path ?
> Thanks
>

any link that talks about different DR options

We want to set up Disaster Recovery for our SQL databases and want to
evaluate the different technologies out there that can do so..( log
shipping, mirroring, stretch clustering, SAN replication, 3rd party,etc.)
and wanted to get a quick overview of the pros and cons of each approach
that may be listed on a link already.
Can someone let me know if there is one out there and send me the path ?
ThanksHi Hassan,
Check these links:
http://technet.microsoft.com/en-us/sqlserver/bb331801.aspx
http://support.microsoft.com/kb/822400
Jonathan
Hassan wrote:
> We want to set up Disaster Recovery for our SQL databases and want to
> evaluate the different technologies out there that can do so..( log
> shipping, mirroring, stretch clustering, SAN replication, 3rd party,etc.)
> and wanted to get a quick overview of the pros and cons of each approach
> that may be listed on a link already.
> Can someone let me know if there is one out there and send me the path ?
> Thanks
>

Any help would be welcomed!

I'm using DMO library.
I'm struggling and pulling out my hair trying to find the XXXX.. property
for the Recovery Model (simple, full,
Server.Databases.Item1....
Does anyone here have
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)Seems to be a Property of the DBOption2 object.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
> I'm using DMO library.
> I'm struggling and pulling out my hair trying to find the XXXX.. property
> for the Recovery Model (simple, full,
> Server.Databases.Item1....
> Does anyone here have
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide informati
on
> without seeing the code. location: Alicante (ES)|||jezz, seeing on dmo I have only:
server.databases.item.dboption...
!!
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>|||I'm sorry...I've got it
Dim oss1 As SQLDMO.DBOption2
?oss1.RecoveryModel
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>

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..
>> >>
>> >>
>> >>
>>