Restoring SQL6.5 database

**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,
I have backup data of Runtyime database, but whe I'm trying to restore it I
get folowing message: "[SQL Server] Database in use. System Administrato
r
must have exclusive use of database to run load." What should I do?
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Hi,
You can not load the database if any user is connected to the specific
database you are trying to load..
So before restoring kill all the process connected.
Use the below script to kill all the process connected in the database.
use master
go
declare @.x varchar(255)
select @.x = @.x + " kill " + convert(varchar(5), spid)
from master.dbo.sysprocesses
where dbid = db_id ('db_name')
exec (@.x)
go
Replace the db_name with your database name.
Thanks
Hari
MCDBA
"Darius" <darius.ram@.takas.lt> wrote in message
news:404ec4ce@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
> I have backup data of Runtyime database, but whe I'm trying to restore it
I
> get folowing message: "[SQL Server] Database in use. System Administra
tor
> must have exclusive use of database to run load." What should I do?
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||If you happened to be using ISQL/w and are actaully in the database you are
trying to restore you will get this error as well.
Rand
This posting is provided "as is" with no warranties and confers no rights.