Restore database to user use this database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restore database to user use this database

Author

Topic

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-05-07 : 01:48:02

hi

how can restore database when user use this database.?
to posibility any error and how can solution

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-07 : 02:19:49

You have to kick everyone out of the database before restoring it. There's no way round that.

--
Gail Shaw

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2008-05-07 : 03:01:29

Cross post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102348

--
Lumbago

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-12 : 02:57:26

Hi,

Go to Run and select services.msc command

and then just right click on database name then u stop it and and then start it

By doing this u can avoid the multiusers

Be cool....

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-12 : 03:52:41

That shuts the entire SQL Server down. If there are multiple databases then you will affect users on all of them. It's a little overkill to get users out of one DB.

--
Gail Shaw

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-12 : 09:14:18

1.Right click on the database which you want to restore.
2.Go to Properties
3.Choose the OPTIONS
4.Change the state of database to single user.i.e., choose the value of Restrict Access to SINGLE user under STATE tab.

Proceed towards the restoring process.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources