Showing posts with label locked. Show all posts
Showing posts with label locked. Show all posts

Monday, February 13, 2012

Backup Jobs Locking ?

When you run a Backup Job (Database or TRN), is the database locked during the database?

If yes, to what extent?

Thanks

There are no locks that are not compatible with any user locks, but only those which could prevent database from deletion, for example.

Friday, February 10, 2012

Backup Getting locked

Hello, I do a full backup daily on a user database. I received an error
telling we the backup failed. (Operating system error = 32(The process
cannot access the file because it is being used by another process.)). How
can I tell what process is locking the file?
Don
http://support.microsoft.com/default...287309&sd=tech
http://support.microsoft.com/?id=833167
"Don" <dons100@.ameritech.net> wrote in message
news:wvLyf.20196$or4.18846@.newssvr12.news.prodigy. com...
> Hello, I do a full backup daily on a user database. I received an error
> telling we the backup failed. (Operating system error = 32(The process
> cannot access the file because it is being used by another process.)).
> How
> can I tell what process is locking the file?
>

Backup Getting locked

Hello, I do a full backup daily on a user database. I received an error
telling we the backup failed. (Operating system error = 32(The process
cannot access the file because it is being used by another process.)). How
can I tell what process is locking the file?Don
http://support.microsoft.com/defaul...;287309&sd=tech
http://support.microsoft.com/?id=833167
"Don" <dons100@.ameritech.net> wrote in message
news:wvLyf.20196$or4.18846@.newssvr12.news.prodigy.com...
> Hello, I do a full backup daily on a user database. I received an error
> telling we the backup failed. (Operating system error = 32(The process
> cannot access the file because it is being used by another process.)).
> How
> can I tell what process is locking the file?
>

Backup Getting locked

Hello, I do a full backup daily on a user database. I received an error
telling we the backup failed. (Operating system error = 32(The process
cannot access the file because it is being used by another process.)). How
can I tell what process is locking the file?Don
http://support.microsoft.com/default.aspx?scid=kb;en-us;287309&sd=tech
http://support.microsoft.com/?id=833167
"Don" <dons100@.ameritech.net> wrote in message
news:wvLyf.20196$or4.18846@.newssvr12.news.prodigy.com...
> Hello, I do a full backup daily on a user database. I received an error
> telling we the backup failed. (Operating system error = 32(The process
> cannot access the file because it is being used by another process.)).
> How
> can I tell what process is locking the file?
>