Actually this is pretty easy.

If you NEVER EVER EVER want instance 2 to fail over to node 1 and only ever be on node 2 or 3 you...

Well You will need to download the Microsoft Access Database Engine from MS, it is version 14.x I believe and install it on the server. Another option is to...

I'm guessing 64-bit SQL.. HAve you installed the 64-bit ACES drivers?

CEWII

All excellent posts and points..

Did you see anything in the windows eventlog during those periods?

CEWII

I'm with Lynn, this isn't going to happen on its own, something has to DO it. And depending on version of SQL depends on what your options are. ...

That is strange.

The job that calls the first one is owned by the same user that owns the others? but then again that wouldn't really matter, backups are executed...

Hadn't thought of the SPNs, good reminder, thanks.

CEWII

Perry Whittle (4/7/2012)

---

Elliott, this is a Windows 2008 cluster?

Are the SQL server services using group or SID based security?

Are your domain admins migrating accounts from domain A to domain B...

You are very welcome.

CEWII

I'm actually a little fuzzy what is being asked..

CEWII

See this link:

http://msdn.microsoft.com/en-us/library/ms403356.aspx[http://msdn.microsoft.com/en-us/library/ms403356.aspx

CEWII

While it feels hacky I think that is the way to do it.. About the only other way I could think about would be to create a table in...

I would probably have...

I ended up not filtering myself. And it works well.

In SSMS if you right click on the table and get properties, if you go to storage under Filegroups if...

Thats a big table, I've only got about 4M but about 1.4TB of space used. And this helped me a lot. Keep in mind they have to be...