"Andrea Montanari" wrote:

> hi,
> ActiveMind wrote:
> > Hello there,
> >
> > Is it possoble to to do MSDE backup from windowsXP- Control
> > Panel(Admin tools) by stopping the service, copying mdf anf ldf
> > files.? Does any body know how to restore from there then?
>
> yes, it is...
> you can stop the server instance, copy the relevant physical files to a
> backup media or "restore" them from the media to the original location...
> this is, however, not a backup but a OS file related activity... usually you
> shold not have permissions to access the location of the physical storage
> with the "running" Windows account and you should provide backup/restore
> feature via the native SQL Server functionnalities...
> you loose the possibility of warm backup letting the database(s) and the
> server be available during file copy operations, you loose the possibility
> to design a serious backup plan, even automatically performed via SQL Server
> Agent (MSDE 2000) or via Windows AT native scheduler (SQLExpress).. you
> loose the possibility of differential backups, log backup....
> all you do, this way, is a copy like you did with Access (nothing against
> Access :D) of the database files, but not a backup strategy... you should
> even remember to backup system databases for disaster recovery scenarios..
> personally I'd never trust an ISV telling me to stop the server to perform
> this kind of "backup" and I'd trash it's application...
> but, yes, it is possible...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>