Make a manual backup for some database

[Xaplytz]

Hi everybody<br>I have a department here whose want I make a program&nbsp;&nbsp;to allow them make their own backup&nbsp;&nbsp;for their database without using the SQL-backup.<br><br>What is warring me is not the backup is when somebody of this peoples could need to make a restore.&nbsp;&nbsp;Because could crash with the rulers business of the database.<br><br>If somebody have done this before I will appreciate any commentaries.<br><br>Thank.<br>&nbsp;&nbsp;<br><br>

 

[jnicho02]

If you are talking about NT file backups then I have some experience of doing this in 6.5.<br><br>It is possible to back up the files that make up databases so that you could restore the whole lot in the event of device failure. However, if the SQL Server is up then the files will be being accessed and won't go onto a file backup, you would therefore have to schedule a server shutdown and restart after the file backup.<br><br>This was in the days when SQL Server backups were deathly slow and we had a really big database, a file system backup was much faster. Now that they work better and considering the difficulties involved my advice is <i>&quot;don't even go there!&quot;</i>. <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>