Difference between revisions of "SQL 2000 and AS 2000 Backup Procedure"

From DataSelf Knowledge Base
Jump to navigation Jump to search
(Created page with "{{#breadcrumb:MS SQL Server}} Category:Microsoft SQL Server Category:Microsoft SQL Server Troubleshooting The DataSelf BI backup procedure should include the followin...")
(Blanked the page)
Line 1: Line 1:
{{#breadcrumb:MS SQL Server}}
[[Category:Microsoft SQL Server]]
[[Category:Microsoft SQL Server Troubleshooting]]
The DataSelf BI backup procedure should include the following steps:
1. Setting up a procedure to back up the folders and files below on a schedule basis.
- Folder for the DataSelf ETL metadata:
  C:\Program Files\DataSelf\DataSelf ETL\SYS
- Folder for DataSelf reports. From this folder, you just need to backup report metadata files (usually bbk and xls files):
  C:\Program Files\DataSelf\DSBI_Client
- Folder for your cube database:
  C:\Program Files\Microsoft Analysis Services\Data
- File for your cube database metadata:
  C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb
2. Backing up the data warehouse SQL database. The procedure below will allow you to configure SQL to do database backups on a schedule basis.
- Open Enterprise Manager, expand tree to Microsoft SQL Servers > SQL Server Group > server name > Databases > select data warehouse database
- From the Tools menu, select Database Maintenance Planner.
- Click Next and then select the databases that you want to create a plan for. You can select more than one database.
- Click Next, to provide options for optimizing the performance of your database. You may skip this step for backup procedures.
- Click Next to proceed to the Database Integrity Check screen. Integrity checks examine allocation and structural integrity of the tables and indexes in your database. It is recommended that you run these checks prior to backing up your database.
- Click Next to display the Specify the Database Backup Plan screen. This step allows you to create an automated backup as part of your maintenance plan.
- Click Next to specify further parameters for your backup, such as where to store your backup file.
- Click Next. You may skip this step for simple backups.
- Click Next. You may skip this step for simple backups.
- Click Next. You may skip this step for simple backups.
- Click Next, to bring up the final screen in the Database Maintenance Plan Wizard. Provide a name for your plan, review your options, and click Finish.
We highly recommend that the backup files are stored on a separate media (not in the local server’s storage devices).

Latest revision as of 03:57, 24 February 2015