Home > X++ stuffs > How Maintenance Plans needs to be created for a DB in SQL

How Maintenance Plans needs to be created for a DB in SQL

 
           For testing any ERP system (i.e. AX, SAP) functionality/performance we require data. Since dataset plays a vital role in the production environment it would be a good idea if we have a regular backup of the data. So SQL Server provides one such scheduling known as “Database backup”

Using SQL Server Management- Maintenance Plans we can do Database backup Scheduling. Please find the attached document which shows “How Maintenance Plans needs to be created for a given DB”. Maintenance plans through wizard is an easiest option which is available.

Downloading Link: http://cid-264a0056cbcbb1d3.skydrive.live.com/self.aspx/.Public/ScheduleBackup.doc

Happy AX2010 Star

Advertisements
Categories: X++ stuffs
  1. Anitha
    January 29, 2010 at 3:27 pm

    Awesome!!! It is useful in real time scenario when users forget to take data back up frequently and later worry when there is any loss or discrepencies in the current data.. This article helps in such situations….

  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: