Tuesday, February 14, 2012

Backup

I have a 2003 server with MSDE on it. When I attempted to backup this server
from another server using Arc Serve, the backup was incomplete because it
could not backup the MSDE database files because they were in use.
Does anyone know of any commands that I may be able to run in a .BAT file to
backup an open database? Or if I have to shut the database down before a
backup, what are the commands to do that? I have searched the Internet and
can not find too much information. Any help is greatly appreciated.
Thank you.
hi,
dlmcguire77 wrote:
> I have a 2003 server with MSDE on it. When I attempted to backup this
> server from another server using Arc Serve, the backup was incomplete
> because it could not backup the MSDE database files because they were
> in use.
> Does anyone know of any commands that I may be able to run in a .BAT
> file to backup an open database? Or if I have to shut the database
> down before a backup, what are the commands to do that? I have
> searched the Internet and can not find too much information. Any help
> is greatly appreciated.
MSDE, as long as SQL Server, supports "hot" backup... backup must be
intended as the native SQL Server backup and not the OS backup... for the
least, you have to stop the server (locally via NET STOP service_name or
remotely via SQL-DMO or whatever)...
if you nead an OS backup I'd suggest to "native" backup MSDE database(s) you
are interested with via the standard
BACKUP DATABASE ...
(http://msdn.microsoft.com/library/de...ba-bz_35ww.asp)
to a specific location and then back it up via OS facilities that file...
this will help not to have down times for your server...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||.... or.. have a look at
http://www3.ca.com/Solutions/ProductOption.asp?ID=2748
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment