Hi,

I work on a remote SQL Server by registering it in my Enterprise Manager.

I do a lot of changes everyday. Sometimes I screw up things in the database.

Is there a way to take backups every week(schedule) and then when some thing goes wrong in the database I cam restore a particular week's database.

If yes, how to it.

Thanks
Kiran

are you renting a space on the server? 


  I work on a remote SQL Server by registering it in my Enterprise Manager.

  I do a lot of changes everyday. Sometimes I screw up things in the database.

  Is there a way to take backups every week(schedule) and then when some thing goes wrong in the database I cam restore a particular week's database.

  If yes, how to it.

  Thanks
  Kiran

Hi,

See the Maintenance plan wizard to backup the database. In the wizard you could choose the backup schedule
based on your requirement. Maintenance plan can be accessed using Enterprise manager -- Management -- Maintenance plans..

Thanks
Hari
SQL Server MVP


  I work on a remote SQL Server by registering it in my Enterprise Manager.

  I do a lot of changes everyday. Sometimes I screw up things in the database.

  Is there a way to take backups every week(schedule) and then when some thing goes wrong in the database I cam restore a particular week's database.

  If yes, how to it.

  Thanks
  Kiran

dts package runs ok but job fails
SQL PUZZLE
recovering database from expired trial version
Large table management and Partitioned Views
how to configure SQL Server 2kEE to utilize 7 of 8GB on Win2k3
Anyway to tell if this is a network issue!
frequent timeouts on SQL Server 2000
Dictionarry order question
Parameter Queries
DBCC DBREINDEX