Backup

I need to develop a backup plan for my SQL Server using the Databse
Maintenace plan. What is the recommended configuration to backup the server.
I will be backing it up to the file system first and tehn eventual backup it
up to tape via a nother server.
Hi George
There is never one definite answer to this, you should read the topic
"Designing a Backup and Restore Strategy" in Books online. Your backup needs
will be governed by things like the risk system failure and loss of data, the
time required to restore the system and against the effect on hardware such
as space requirements, duration of backup process and resources required to
backup the system.
John
"George Schneider" wrote:

> I need to develop a backup plan for my SQL Server using the Databse
> Maintenace plan. What is the recommended configuration to backup the server.
> I will be backing it up to the file system first and tehn eventual backup it
> up to tape via a nother server.
>
|||Hi George.
Thanks for John's suggestion.
You may also refer to
<http://msdn.microsoft.com/library/de...-us/adminsql/a
d_bkprst_9zcj.asp>
If there is anything unclear, please let me know. I'll be glad to be of
assistance.
Best regards,
Vincent Xu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--[vbcol=seagreen]
<georgedschneider@.news.postalias>[vbcol=seagreen]
server.[vbcol=seagreen]
backup it[vbcol=seagreen]