Company database SQL Server 2008 R2, 80 gb database files, log files, 596 gb and perform a backup job to quote the following mistakes when


Database in D disk, backup destination partition is D (there is insufficient space on the other partitions), D the remaining space at present is 965 gb, homework from 22 p.m., 3 a.m. the next day the mistake, please backup error what could be the cause?
Thank you for your attention!

CodePudding user response:

The log file truncation, make so big what? Do not have a look at the basic optimization Settings,

CodePudding user response:

Please check the D disk is FAT32 format, the maximum limit of a single file is 4 gb.

CodePudding user response:

refer to the second floor started the first response:

please check the D disk is FAT32 format, the maximum limit of a single file is 4 gb.

No, the database file itself, on the D is NTFS, undoubtedly the LDF is 600 g

CodePudding user response:

The database modifications for simple mode, first contraction database log, then try the backup.

CodePudding user response:

refer to 6th floor started the first response:

database modifications for simple mode, first contraction database log, then try the backup.

Thank you to solve! I'll give it a try