SQL Server Backup Database to Tape

SQLUSA.com

SQL 2008 GRAND SLAM ON 49 CD

SQL Server Training	SQL 2005 Scripts	SQL 2008	Articles
SQL JOBS	News	Format	Developer

How to backup a terrabyte database to tape?

Assume you have a large one terrabyte database or several databases adding up to a terrabyte. With today's (2005) technology, it takes around 20 hours to back it up to tape. To speed it up, you would have to configure more tape drives. Multiple backup devices e.g. \\.\TAPE0, \\.\TAPE1, \\.\TAPE2 and \\.\TAPE3, work in parallel thus reducing backup time to 5 hours in this example.

How to: Back Up to Tape or Disk (SQL Server Management Studio)

Order SQL 2008 GRAND SLAM Today!

SQLUSA.com Home Page SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.

Accounting
Administrative
Advertising
Arts
Architecture
Banking
Business Intelligence
Career Jobs
Celebrity
Computer
Consulting
Customer Service
Education
Engineering

Entertainment
Entry Level
Executive
Federal
Finance
Government
Hardware
Healthcare
Hospital
Human Resources
Information Technology
Insurance
Internet
Job Openings

Laboratory
Law Enforcement
Legal
Logistics
Manufacturing
Marketing
Medical
Military
Nursing
Pharmaceutical
Physician
Public Relations
Publishing
Real Estate

Restaurant
Retail
Sales
Social Media
Software
SQL Database
Telecomm
Therapist
Training
Transportation
Truck Driver
Travel
Web
Work from Home

FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts

JOIN US ON TWITTER

Copyright 2005-2012, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.