February 12, 2003 at 7:35 am
I stopped SQL services. Backed up my RAID5 drive to tape (complete backup). Replaced my RAID5 disks from ~8G to ~36G drives (~34G to 114G total for the drive). Restored the drive from tape and restarted SQL 7.0. Everything appeared to be fine. 2 days later, someone else installed SP4+.
@@version gives:
Microsoft SQL Server 7.00 - 7.00.1077 (Intel X86)
Sep 6 2002 15:10:15
Copyright (c) 1988-2002 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
SQL then attempted a full backup of the database the next morning and failed immediately with:
1453(Insufficient quota to complete the requested service.) failed
I do not have disk quota enabled.
I tried increasing the SQL server RAM size.
I've tried creating and performing a new backup.
Keeps failing with the same message.
When I upgraded the RAID5 disks. I did not know the orignal volume label. So, I entered what I thought it was. Could that be a factor?
February 17, 2003 at 9:33 am
Try to backup to a UNC drive. Also are you running the service accounts with a domain account. Did the person that installed sp4 change the account with which sql runs. I would look at the latter first. Sounds like a permissions issue to me.
Tom
February 17, 2003 at 12:53 pm
Thanks for your suggestions.
The account which SQL runs was not changed.
The service accounts are with an administrator account on the local server(server in a workgroup not in a domain).
I can successfully backup newly added DBs or any DB that was NOT previously backed up on the previous RAID drives. Backing up existing DBs (that were previously being backed) to ANY specified location fails.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply