Microsoft sql server 2008 r2
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

Microsoft SQL Server 2008 R2 PowerPoint PPT Presentation


  • 87 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Microsoft sql server 2008 r2

Microsoft SQL Server 2008 R2

IT:Network:Applications


Sql server administration tasks

SQL Server Administration Tasks

  • Verify data

  • Import data

  • Backup data

  • Schedule/backup/maintain databases


Verify data

Verify Data

  • Review target datafor consistency/integrity

  • Define delimiter

    • Comma, tab, etc

  • Remove inconsistencies if possible

  • Possibly define columns


Verify data1

Verify Data


Verify data2

Verify Data

  • Align indexes/table links (if multiple relationships exist


Import data

Import Data

  • Open Microsoft SQL Server Management Studio

  • Connect to your SQL Server

  • Right click on your databaseTasksImport Data


Import data1

Import Data

  • Select Import data

  • Choose data source

  • Choose columns

  • Complete import


Import data2

Import Data


Backup data

Backup Data

  • In SQL Server Mgmt Studio

    • Right click on DatabaseTasksBackup

      • Delete “default” backup destination and Add new one


Backup data1

Backup Data


Backup data2

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


Schedule backup maintain databases

Schedule/backup/maintain Databases

  • SQL Server MgmtStudioManagementMaintenancePlansMaintenance Plan Wizard


Schedule backup maintain databases1

Schedule/backup/maintain Databases


Schedule backup maintain databases2

Schedule/backup/maintain Databases

  • Select maintenance tasks

    • Integrity

    • Rebuild Index

    • Backup

    • Etc.


Questions

Questions?


  • Login