March 10, 2005 at 6:41 am
my daily log and database backup failed with the error3202
odbc sqlstate:4200 error3202.
any ideas?
[font="Comic Sans MS"][/font]It is what it is.
March 10, 2005 at 8:48 am
4200 or 42000? I could find no references to 4200/3202, but several for 42000/3202 by searching on http://www.google.com . Having found that, I re-searched Books Online. 42000 is for "syntax error or access violation". At least one site from the google search provided the following text -
Microsoft SQL-DMO (ODBC SQLState:42000)
Error 3202: Write on \\servername\transaction\200_logshipping_init.bak fails, status 64, See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.
Be sure to check the SQL Server error log and also the Application log on the server. Could provide additional information. My guess is that for whatever reason, it couldn't write to the backup location. Have you checked to see if the disk is full????
Steve
March 10, 2005 at 11:14 am
Disk was full. Thanks.
[font="Comic Sans MS"][/font]It is what it is.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply