Cannot backup database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Cannot backup database

Author

Topic

vjalwal
Starting Member

4 Posts

Posted - 2006-11-11 : 05:27:31

Hi All,

I'm Surinder, new to this team. I need ur help...

I'm not able to take backup of my database in SQL server 2000.. I'm getting this error..

2006-11-11 13:42:16.26 spid74 Internal I/O request 0x10EE4A50: Op: Write, pBuffer: 0x10F60000, Size: 983040, Position: 4294449664, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFF81A00, OffsetHigh: 0x0, m_buf: 0x10F60000, m_len: 983040, m_actualBytes: 0, m_errcode: 112, BackupFile: D:\11112006.bakl

2006-11-11 13:42:16.26 backup BACKUP failed to complete the command BACKUP DATABASE [VISTA] TO DISK = N'D:\11112006.bakl' WITH NOINIT , NOUNLOAD , NAME = N'VISTA backup', NOSKIP , STATS = 10, NOFORMAT

My database size is 4 GB & I have disk space of 30 GB, but stii I'm not able to take backup..
Pls help me as this is my live database & I don't want to loose my data.

Thanks

Surinder

Surinder

Kristen
Test

22859 Posts

Posted - 2006-11-11 : 06:24:42

"My database size is 4 GB"

is that the size of your LDF, MDF, both combined, or something else? (e.g. "Used space" reported by Enterprise Manager)

Kristen

Kristen
Test

22859 Posts

Posted - 2006-11-11 : 06:31:30

Other possibilities are:

SQL Server Agent Service does not have permissions to the target folder

D: is not formatted for NTFS (thus you are exceeding the 4GB limit for a FAT file)

Kristen

vjalwal
Starting Member

4 Posts

Posted - 2006-11-11 : 06:32:05

my ldf is 10mb, mdf is 4.22gb & I've disk space of 30GB

Surinder

Kristen
Test

22859 Posts

Posted - 2006-11-11 : 06:35:45

OK, so no worry about your LDF size.

Did you see my second reply earlier - which probably crossed with your reply?

Kristen

vjalwal
Starting Member

4 Posts

Posted - 2006-11-11 : 06:43:51

Kristen, my d: drive fat is FAT32, let me check to take backup on ntfs to verify if thi8s problem due to fat32 or not..

Surinder

vjalwal
Starting Member

4 Posts

Posted - 2006-11-11 : 06:56:17

Thanks alot Kristen, it was the problem due to FAT32, I tried to take backup in NTFS, it worked..
Thanks Alot...

Surinder

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-03-06 : 08:22:30

Hi Kristen
I am facing the same problem and I checked My H : Drive it's NTFS. Could you help me how to check SQL Server Agent Service permissions to the target folder ?
Or what could be other possibilites, I have enough disk space on Drive around 192 gigs free

SQL IN Minds

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-06 : 22:51:59

Is h:\ local disk on sql server? Ensure sql agent service account has permission to create file on h:\.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources