gurneyn
asked on
SQL Backup : Error 3201 (dbswritecheck)
I am getting the above error when tring to backup to a device on the local machine. I can backup to another device located in the same directory. I have checked the permissions and have Full Control. These worked before I went on vacation but now fail. I can get around the problem by setting up all my backups to write to a new device but don't really want to do this. Help !
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
Guy Hengel [angelIII / a3]
Please check out if the NTAccount the SQL service(s) run do have the permissions...
ASKER
Yes, it has admin rights to machine and domain.
Hi,
The description of the Error is as follows.
Can't open dump device '%.*s', device error or device off line. Please consult the SQL Server error log for more details.
Have you tried looking in the Error Log.
Cheers,
T.
The description of the Error is as follows.
Can't open dump device '%.*s', device error or device off line. Please consult the SQL Server error log for more details.
Have you tried looking in the Error Log.
Cheers,
T.
ASKER
Error log says 'dbswritecheck : Read of first trailer failed'.
ASKER
Adjusted points from 50 to 100
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, pretty new to this - how do I run DBCC ?
Hi,
If you have access to Books On Line you can check the correct Syntax for it there.
eg.
DDBC CHECKALLOC [(database_name [, NOINDEX])]
DBCC is used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. DBCC is the SQL Server "database consistency checker."
T.
If you have access to Books On Line you can check the correct Syntax for it there.
eg.
DDBC CHECKALLOC [(database_name [, NOINDEX])]
DBCC is used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. DBCC is the SQL Server "database consistency checker."
T.
Hi,
OOPS - Should have read DBCC of course.
If you have access to Books On Line you can check the correct Syntax for it there.
eg.
DBCC CHECKALLOC [(database_name [, NOINDEX])]
DBCC is used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. DBCC is the SQL Server "database consistency checker."
T.
OOPS - Should have read DBCC of course.
If you have access to Books On Line you can check the correct Syntax for it there.
eg.
DBCC CHECKALLOC [(database_name [, NOINDEX])]
DBCC is used to check the logical and physical consistency of a database, check memory usage, decrease the size of a database, check performance statistics, and so on. DBCC is the SQL Server "database consistency checker."
T.
Hi,
You could also look at the following article from Microsoft -
http://support.microsoft.com/support/kb/articles/Q166/7/58.ASP?LN=EN-US&SD=gn&FR=0
I'm not sure if it helps.
T.
You could also look at the following article from Microsoft -
http://support.microsoft.com/support/kb/articles/Q166/7/58.ASP?LN=EN-US&SD=gn&FR=0
I'm not sure if it helps.
T.