Last year when we tried to do DR testing first time, it was bad ( see my previous posts ). We learnt our lessons, perfected our methods, RP is working...

Also,

I was wrong in my judgement here. I was afraid of taking db offline or attaching/detaching thinking that we will lose it.

Until yesterday I was not aware that this...

Gail,

Interestingly, we decided to take a chance and turn sql services off. After that we copied the mdfs and ldfs to different server, attached, ran dbcc, it came out clean.

The...

Thanks guys.

I can't believe I don't get answers in sql server central forums. Hopefully we are not the first shop to go through SAN migration in the environment. This is time...

We installed standalone sql servers with system dbs at DR.

We created jobs on Prod servers to script logins, permissions, jobs etc and robocopy scripts to the relevent sql servers...

I always thought subscriptions will be created with migration - I mean backup and restore of reportserver and reportservertempdb. I did not come across the step to restore msdb. Is...

Sorry. I posted it twice. Only 12 views in RS forun and 59 views here. Regardless there are 0 answers..

Guys,

We tested our DR strategy using RecoverPoint.

It was a disaster. Most critical databases did not attach.

Msg 1813, Level 16, State 2, Line 2

Could not open new database 'DRTest'. CREATE...

I am on it.

Thanks a lot for your guidance.

Thanks Gail.

I will look into Write order preservation for EMC-Recoverpoint replication and make sure that it is following the correct process not to cause integraty issues.

Simplifying the post hoping to get answer:

We have a 3rd party vendor table with following definition: 7 non-sparse columns and 340 varchar(max) sparse columns:

CREATE TABLE [dbo].[ReportSparseData](

[ReportSparseDataId] [int] IDENTITY(1,1) NOT FOR...

We have nightly restores to DEV environments, weekly to Test and Integration and on demand for Regression testing. There are crazy amounts of restore jobs running every day pulling from...

Ok. It's fixed now.

I had to go to replication related linked servers on publisher and distributor, retype the password for sql accounts to be used for connection and enable 'allow...

Derrick Smith (9/27/2011)

---

I've set it up that way in the past but if you're having issues on your network getting it to work you could always try using a SQL...