Monday, February 13, 2012

Auto logoff?

Is there a way to automatically log people of of SQL Server 2000? I'm running
eEnterprise, and often times when people shut down their PC's they don't
logoff correctly. This messes up my nightly backups.
Is there a way to auto logoff those people that didn't logoff properly?
Omega
You should be able to backup your databases in the middle of the day with
everyone in the system without any problems.
This T-SQL command backs up the master database to a file called master.bak
on the x drive:
BACKUP DATABASE master TO DISK = 'x:\master.bak' WITH INIT
Keith
"Omega430" <omegaizded@.yahoo.com> wrote in message
news:BE7977F1-F359-47CF-A437-4D352C0E6224@.microsoft.com...
> Is there a way to automatically log people of of SQL Server 2000? I'm
running
> eEnterprise, and often times when people shut down their PC's they don't
> logoff correctly. This messes up my nightly backups.
> Is there a way to auto logoff those people that didn't logoff properly?
> --
> Omega

No comments:

Post a Comment