Posted by Greg D. Moore \(Strider\) on 02/23/07 14:19
"blueboy" <matt_meech@hotmail.com> wrote in message
news:1172237955.311495.294700@q2g2000cwa.googlegroups.com...
> Arrr Apologies
>
> here is the info
>
> Executed as user: User domainname\user. Exclusive access could not be
> obtained because the database is in use. [SQLSTATE 42000] (Error
> 3101) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000]
> (Error 3013). The step failed.
>
> Step one runs fine which disconnects users so not sure what the prob
> is? any ideas??
>
Are you sure the job isn't trying to run while in that DB?
> Many thanks
>
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
[Back to original message]
|