gone from SSAs or physically from the drive?

pls post the complete error msg (obscuring filenames if you want)

we no longer have Analysis services (hurrah) having replaced it with Qlikview, but did you stop SSAS, move the 0.db directories to the new location and restart.

amending the data folder...

ejoell 66477 (9/21/2011)

---

George, in the original post dbajunior said "I uncheck db_owner, then click OK." Well in my version of SQL Server 2008, the login mapped to dbo is...

what exactly is not working?

sounds like more work and risk than its worth 🙂

as people connect to the virtual server name,

a) whats the point?

b) does the virtual name fit these new standards?

you can change the safety mode at any time. You wont lose data. there is no need to break and reestablish mirroring.

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

was it error 4014?

this could have been an SSIS package, and as the error suggests it is likely a network issue. these errors are more prevalent on clusters

take everyones advice and just set up regular log backups, that should be your starting point and is a must.

If you want belt and braces and really feel the need...

don't configure it as part of the install, select the files only option during the install then configure it once the install is complete.

its pretty much accept the defaults but...

you would need a log filling alert for each database and a corresponding transaction log backup job per database.

from this it sounds as if the user is dbo of the database (not quite...

thats why I can't find any deadlock info !

trouble is 1222 returns the info in a much easier to read format, so we should be encouraging people to use that trace flag rather than 1204.

thats my point back....

Install RS as a named instance on both nodes, configuring the first install to use databases supported on the cluster. then configure RS as a scaled out install and set...