Can someone help over on this thread? I'm positive the OP needs to rebuild SQL Server, but he seems certain that his backup strategy works and that the issue is...

GilaMonster (3/15/2016)

---

Ed Wagner (3/15/2016)

---

GilaMonster (3/15/2016)

---

Brandie Tarvin (3/15/2016)

---

In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is...

It sounds as if you've never used Data Flow Tasks given your...

Do you know how to create an SSIS package?

Is this a one off run or something...

In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working...

Eirikur Eiriksson (3/14/2016)

---

Brandie Tarvin (3/14/2016)

---

😛

Still not sure if I like...

Leeland (3/14/2016)

---

To get around this, I did have an actual full restore done on another server which wasn't being used at this time so I went through the process of...

Also consider the need for roles during DR. Who is responsible for what tasks is critical to ensure everything gets up and running on time without duplicate effort.

Being fair, Lynn, my...

Steven.Grzybowski (3/14/2016)

---

Brandie Tarvin (3/14/2016)

---

Eirikur Eiriksson (3/12/2016)

---

Brandie Tarvin (3/11/2016)

---

What a wonderful

Still not sure if I like Data Tools or not. It seems very sensitive to every little click of the...

Thank you for posting your workaround and all the detail.

I'm thinking you're correct that the error you receive has nothing to do with the real problem. On the other hand,...

Why do you need a document with SELECT statements?

Why can't you create a bunch of stored procedures and then use Data Flow Tasks with each stored procedure as your Source...

Why do you need a text file for your SELECT statements? Do they change at all?

The obvious answer, which you indicated you might not be able to do because of size, would be to restore the entire database (not just the primary filegroup) down to...