Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backing up and restoring Sql Server
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01329209
Message ID:
01329239
Views:
11
Unless SQL Server is shut down before backup is done, such backup is useless. You should schedule SQL Server backup before network backup. This way SQL Backup files will be included in the full backup.

We use Backup all databases on a server script by Nigel Rivett from http://www.nigelrivett.net/BackupAllDatabases.html

>We have deployed Sql Server on site. Backup is dobe by Hardware guys and I understand a backup of full network drive is
>done each night to tape.
>(This includes a Folder called AppSqlServer which holds the MDF and and the LDF files.)
>
>Is this sufficient ? If there was a need to restore, How would I do this
>Any alternatives or good practises would be welcomed
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform