I was able to successfully load my tables using the Bulk Insert SQL command, I was hung up a little bit on finding the right delimiter. Anyways, I need to backup my database, however, I am receiving an error message when I am trying to backup the database using right-click->Task->Backup and the below SQL Backup command:

use master
go

BACKUP DATABASE Intranet
TO DISK = 'c:\SQL Backups\Intranet.Bak'
WITH FORMAT,
MEDIANAME = 'Intranet',
NAME = 'First Full Backup of CSA-Intranet';
GO

I am receiving this error message when attempting to backup the database both ways -

Msg 3271, Level 16, State 1, Line 2
A nonrecoverable I/O error occurred on file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Intranet.mdf:" 23(Data error (cyclic redundancy check).).
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.

The data file for the Intranet database does exist at the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Intranet.mdf location. What am I missing here? Any further help would be appreciated.

Patrick Quinn

Carlson Wagonlit Travel DBA