I have a SQL Server 2000 database with numerous users. I would like to
backup the database without any users entering the database. I would like to
place the database in single-user mode and backup the database.
Could I have problems with this procedure.
Thanks,In order to place it in single user mode you will have to force any other
users out first. But why do you want to do this as it is fine to backup the
db while users are in it.
--
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:3F86F412-2679-4F11-9DA3-1B1D554DDF86@.microsoft.com...
> I have a SQL Server 2000 database with numerous users. I would like to
> backup the database without any users entering the database. I would like
> to
> place the database in single-user mode and backup the database.
> Could I have problems with this procedure.
> Thanks,
>
No comments:
Post a Comment