I believe that you are seeing this error because you have not specified the share for the snapshot directory correctly. The error is indicating a local path ('D:\SQLProgramFiles\MSSQL10.STD08\MSSQL\ReplData\unc\[INSTANCE_NAME]\[DATE]\FILE_5.pre). You can...

Have you tried this: http://www.sqlservercentral.com/articles/Administration/68271/

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

By Rudy Panigas, 2009/11/03

Even if someone did get a hold of a backup log, they couldn't simply read the transactions even with 3rd party log readers since (I believe) they need the database...

I have seen this occur when the master database has been restored using a different name and the registry entries were changed to reflect this (common practice if restoring the...

Hey David,

Without knowing the exact error you were seeing with the “Execute As” option, I am thinking that it was because this system view will always be outside of the...

Hey IC, the first thing you might want to try is to ping and telnet to that server with the specified port to make sure it is resolving correctly; from...

In looking at a white paper for “Distributed/Heterogeneous Query Processing in Microsoft SQL Server” (http://ieeexplore.ieee.org/xpl/freeabs_all.jsp?arnumber=1410211, I know this isn’t a distributed query, but it’s what I had here...

Okay, you’re right- wasn’t giving a whole lot of thought to my previous postings. So I haven’t tried this and am not working today to test it on any of...

Rather than copy all of the data into a new table, you might try creating a new not null column on the existing table and copying the data into the...

I would create an index on the column(s) I want to alter if there isn’t already one and if the log is filling up, can you set it to simple...

Hey Mike, I was speaking more toward the original post where they stated that they knew the procs that were causing the issue. In your case, I agree that at...

These DBCC commands remove all plans from the cache and chances are that this is simply a single (or maybe a few) bad plan(s) so if you know the name...

Since the instance does need model, but doesn’t need MSDB to start, try renaming your model to MSDBData.mdf (keeping a copy of that original MSDB file handy of course), start...

Cool, I was just replying when I saw your last post. Glad it will work for you.

There are a lot of good scripts around, but here is a script that I use frequently (comment out/ remove the drive letter if that is not of interest to...