You are here: Re: Restore SQL DB with correct logical file names « MsSQL Server « IT news, forums, messages
Re: Restore SQL DB with correct logical file names

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация