CODEWITHSUNDEEP
sqlsql-server
José Marquês
José Marquês

Reputation: 61

Backup database - SQL Server

I need make a backup of my SQL Server database. When I try, I get this error:

System.Data.SqlClient.SqlError: Read on "c:..." failed: 23(...)(Data error (cyclic redundancy error))

Now, I'm trying to run this command:

DBCC CheckDB ('MYDATABASE') WITH NO_INFOMSGS, ALL_ERRORMSGS

But I get this error

Msg 8921, Level 16, State 1, Line 18
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

What can I do? I just need make a backup.

I'm using Microsoft SQL Server Management Studio.

Upvotes: 0

Views: 990

Answers (1)

RKS
RKS

Reputation: 1

First of all, check the Service Account used for the SQL Server Instance from Services. Ensure the service account have enough permission for read/write at the exact location for Backup in Physical Disk. Ensure the the user (the user you using to login in SQL Instance) have enough permission to perform backup.

Final option to recover the data from the database is create another database with same tables (blank) in different machine in different SQL instance, then Export all the database to new database using Management studio (Right click on the Database > task > Export Data)

Upvotes: 0

Related Questions