Sunday, March 11, 2012

Backup database

This is a multi-part message in MIME format.
--=_NextPart_000_0099_01C58847.15C5D770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Is there a way to backup database every week and the restore a = particular week's database.
Thanks
Kiran
--=_NextPart_000_0099_01C58847.15C5D770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,

Is there a way to backup database every = week and the restore a particular week's database.

Thanks
Kiran
--=_NextPart_000_0099_01C58847.15C5D770--Of course. have you looked at Backup and Restore T-SQL commands and topics
about Scheduled Jobs in Books OnLine?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

No comments:

Post a Comment