Deleting data files while database is online (.mdf, .ldf )

Question

Question by Darrell · Jun 16, 2010 at 11:07 PM · delete datafiles

Deleting data files while database is online (.mdf, .ldf )

I realise that an OS level lock is put on the data files themselves while they are in use, however I was wondering if there are any conditions in which a database is not offline/detached in which these files can be moved or deleted?

The reasoning behind this is whether it is a safe enough assumption to assume that you don't need to worry about deleting a live database at the file level due to the implied lock.

Thanks!

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-06-17T02:08:24Z

Best Answer

Answer by Rob Farley · Jun 17, 2010 at 02:08 AM

You may find times when the files aren't locked, and I wouldn't consider it a safe assumption. I've never looked hard enough to find out when those times are, but I'm sure I've been able to touch those files occasionally.

1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Deleting data files while database is online (.mdf, .ldf )

1 Reply

Your answer

Follow this Question

Related Questions