microsoft sql server 2008 r2
Download
Skip this Video
Download Presentation
Microsoft SQL Server 2008 R2

Loading in 2 Seconds...

play fullscreen
1 / 15

Microsoft SQL Server 2008 R2 - PowerPoint PPT Presentation


  • 127 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Microsoft SQL Server 2008 R2' - manasa


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 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
backup data
Backup Data
  • In SQL Server Mgmt Studio
    • Right click on DatabaseTasksBackup
      • Delete “default” backup destination and Add new one
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 databases2
Schedule/backup/maintain Databases
  • Select maintenance tasks
    • Integrity
    • Rebuild Index
    • Backup
    • Etc.
ad