*sigh*

still there. what is the worst that could happen if i drop (rename) that sparse file while sql is down?

not a HUGE problem, but i like to run integrity checks everyday if i can. i have 10 servers with way more activity than this server/db that i am...

and yes, when the instance starts, the file goes into use by sqlserver.exe.

i reiterate though, that there is not 1 spid using it. so i am left...

thanks for the reply.

yes, i can. i can create a new snap of the same db with a different name then delete it without a single problem.

i have managed...

I am also having a very similar issue. Did this ever get resolved?

Thanks for the post.:-D

Brilliant minds think alike - I am setting up a test server right now. I also found this KB that says I can restore the system...

ha! I am happy to report that I have found issue and resolved this problem.

My SHARE security was different than my NTFS security on my snapshot folder.

I was able...

My issue then was that there were orphaned subscriptions on my subscriber server after I had completely ripped replication out on the publisher. I had to go over to...

thanks for the information again.

Carl - the "tautology" was a typo. Even though it was corrected, the original query ran in excess of an hour.

good information guys, thanks!

Wow!

What version of SQL are your running? I only ask, because you might be able to find something useful in the 2005 dynamic management views. This site...

Make sure your tempdb is NOT on the same drive as your data file.

It is easy to move if it is sharing the same drive:

use master

go

Alter database tempdb...

Double darn check that you really aren't missing an index. After that I would update your statistics on both tables.

update statistics tablea

go

update statistics tableb

go

Good luck,

Deb

I did run filemon - good tool btw!

It is my service account user that is getting the AccessDenied on that directory.

However, I've given that account Full Control.

I moved all my...

I had yet another issue with database mail. Where the above steps didn't work.

Apparently, when you drop and recreate a new profile, the registry doesn't always get changed to...