November 10, 2010 at 5:53 am
Hi Experts,
I have an issue with lite speed backup, hope anybodu can help. below is the error i am getting
Executed as user: NYWEB\sql8.
Quest SLSSQLMaint Utility.
Logging on to SQL Server 'WILUPSSQLINV\INVITE' with Windows Authentication
Logged on to SQL Server 'WILUPSSQLINV\INVITE'
Starting maintenance plan 'UPSSQLC UserDB (Full)' on 11/9/2010 12:30:20 AM
[1] Database "UPSInvite": Backup database... LiteSpeed(R) for SQL Server Version 5.2.0.1240 Copyright 2009 Quest Software, Inc. Registered
Name: Admin Msg 60900, Level 16, State 1, Line 0: Error saving data to file. Thread: 1
BACKUP DATABASE is terminating abnormally. A nonrec slssqlmaint failed [SQLSTATE 42000] (Error 50000). The step failed.
thanks
Puneet
November 10, 2010 at 6:48 am
Puneet
I've never seen that error before. If you have a support agreement with Quest, use it - you're paying for it, after all! Just e-mail support@quest.com.
John
November 10, 2010 at 6:51 am
Thanks, just to add
below is the SQL error i am getting
BackupMedium::ReportIoError: write failure on backup device 'VDI_C4D30BA6-0EB3-47AA-AC2C-72030AA92979_1'. Operating system error 1(Incorrect function.).
may be you have any idea looking at this
November 10, 2010 at 6:56 am
Are you attempting to back up to a CD/DVD writer, by any chance?
John
November 10, 2010 at 6:59 am
No, i am taking backup on UNC path
November 11, 2010 at 6:05 am
Do anybody have any idea?
November 11, 2010 at 6:17 am
do you have sufficient space for the full backup file?
does the user running the backup (or service account) have the correct permissions to the UNC path? Running a exec xp_cmdshell 'dir "UNC PATH"' will tell if you have read permissions.
November 12, 2010 at 5:29 am
Mostly it will be permission issue.
make sure you have full access on the UNC path.
November 12, 2010 at 5:31 am
UNC Path has Space and the Login hasfull access on that location.
November 12, 2010 at 8:42 am
Un tick 'Verify integrity of the backup after completion' and try...
November 16, 2010 at 6:37 am
its already unchecked, any other idea?
November 16, 2010 at 6:44 am
Yes. Try backing up to a local drive. If that works then you know your problem is with the network - permissions, communication, whatever. Check that the network share you're trying to back up to isn't a removable media such as CD or DVD. Ask yourself the following questions. Does this still happen if I try to back up a different database? What about if I try to back up a database from a different server to the same location? Did this work at any time in the past? If so, what has changed?
John
November 16, 2010 at 6:46 am
It definitely looks like a permissions issue on the destination folder....
Can you add\remove a file to that UNC path as that windows user?
November 16, 2010 at 7:17 am
if its a permission issue how my Tlog backup is running successfully?
its only full backup thats increasing my headache.
when i ran it manually it ran successfully so network issue should not be the case.
thanks for helping guys but still its not over.
November 16, 2010 at 7:20 am
how big is the backup? how long does it take to back when it is successful or if you back it up locally...
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply