1 / 15

Microsoft SQL Server 2008 R2

Microsoft SQL Server 2008 R2. IT:Network:Applications. SQL Server Administration Tasks. Verify data Import data Backup data Schedule/backup/maintain databases. Verify Data. Review target data for consistency/integrity Define delimiter Comma, tab, etc Remove inconsistencies if possible

manasa
Download Presentation

Microsoft SQL Server 2008 R2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft SQL Server 2008 R2 IT:Network:Applications

  2. SQL Server Administration Tasks • Verify data • Import data • Backup data • Schedule/backup/maintain databases

  3. Verify Data • Review target datafor consistency/integrity • Define delimiter • Comma, tab, etc • Remove inconsistencies if possible • Possibly define columns

  4. Verify Data

  5. Verify Data • Align indexes/table links (if multiple relationships exist

  6. Import Data • Open Microsoft SQL Server Management Studio • Connect to your SQL Server • Right click on your databaseTasksImport Data

  7. Import Data • Select Import data • Choose data source • Choose columns • Complete import

  8. Import Data

  9. Backup Data • In SQL Server Mgmt Studio • Right click on DatabaseTasksBackup • Delete “default” backup destination and Add new one

  10. Backup Data

  11. Backup Data • Equivalent Script • BACKUP DATABASE [ABCCompany] TO DISK = N'C:\backup\ABCCompany' WITH NOFORMAT, NOINIT, NAME = N'ABCCompany-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

  12. Schedule/backup/maintain Databases • SQL Server MgmtStudioManagementMaintenancePlansMaintenance Plan Wizard

  13. Schedule/backup/maintain Databases

  14. Schedule/backup/maintain Databases • Select maintenance tasks • Integrity • Rebuild Index • Backup • Etc.

  15. Questions?

More Related