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

😛

Still not sure if I like Data Tools or not....

Windows 10 or Windows 2010?

I don't know of any Windows 2010 release.

What version of Windows was the user upgraded from? And was SQL 2012 32bit also or 64bit?

As an added note, I worked for Iron Mountain Records Management when 9/11 happened. I remember well the tales of the New York office getting people up and running right...

Vyper426 (3/11/2016)

---

No. about 800GB available on that drive.

Just before this, MSDB had been corrupted. We took the backup from the backup system and replaced it. The backup system does not...

What a wonderful day in the upgrade-hood...

Sigh.

So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:

Honestly, the only time I've ever seen the error is if:

1) The login doesn't exist on the server

2) The login exists on the server but doesn't have database level permissions

3)...

Are you sure, absolutely positive, that the user name is spelled exactly the same way on the server as it is in the linked server?