What service or services do I need to stop in order to
complete a offline backup?mssqlserver and sqlserveragent
You are aware of the Transact-SQL BACKUP command, right? This is a =great way to backup your system without taking your databases offline. =Keep in mind that simply because you backup the files that make up a =database (MDF, LDF...), you might not be able to "restore" those files. =
It is better to use sp_detach_db and sp_attach_db OR Backup and Restore.
-- Keith
"Chris" <anonymous@.discussions.microsoft.com> wrote in message =news:032801c3d6fb$9db0c950$a401280a@.phx.gbl...
> What service or services do I need to stop in order to > complete a offline backup?sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment