Monday, March 19, 2012

DB restore

Restoring of db:
error : db not exclusive to dbowner--prevent restore of db
I am looking for the procedure in :
1.Check logged in user on db
2.Send message to them
3.Log them out
4.set db as exclusive to dbo
then the restore process will followSQL MVP Tibor Karaszi has a web site .www.dbmaint.com... There he has some
public stored procedures which allow you to send a net send to everyone
logged in to your server, and kill everyone in a particular database....
that will be a start
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corp (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"werner" <wernerb@.tshwane.gov.za> wrote in message
news:0b9c01c36bc3$607e4ab0$a401280a@.phx.gbl...
> Restoring of db:
> error : db not exclusive to dbowner--prevent restore of db
> I am looking for the procedure in :
> 1.Check logged in user on db
> 2.Send message to them
> 3.Log them out
> 4.set db as exclusive to dbo
> then the restore process will follow
>

No comments:

Post a Comment