0

How do you check if the specified disks or mount points have enough space for database backup.

Improve this question
2
  • 1
    If you're not using compression, the backup will be a similar size to that of your database (it might be a little larger, or smaller, depending on the active transactions). If you're using compression, it'll be smaller, but how much smaller is very hard to calculate; as that totally depends on your database. The "easiest" way is to actually perform a backup. Commented Dec 8, 2018 at 13:46
  • 3
    See this answer for estimating non-compressed backup size. xp_fixeddrives will report available free space. Commented Dec 8, 2018 at 13:48
Related questions
1
Finding available drive space of databases stored on a LUN
9
Calculating DB backup size
6
Best way to find free space in sql server databases?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.