up vote 1 down vote favorite
share [g+] share [fb]

When I backup via stsadm (Stsadm -o backup -overwrite -url %mysite% -backupmethod full -filename %file%) I get a file size of 1.5gb. I just looked on our sql server and the database is around 18gb. I was under the impression that using the 'full' parameter in stsadm was capturing the entire site, am I wrong? Should I be using a 3rd-party utility to do this instead?

link|improve this question
1  
How are you determining the size of your SQL database? – Doug Luxem Jul 19 '10 at 20:07
feedback

2 Answers

up vote 0 down vote

I was looking at the properties of each database to determine the size.

Turns out the log files were getting extremely large. I shrank them following the instructions here: http://geekswithblogs.net/RogueCoder/archive/2008/06/03/122588.aspx

link|improve this answer
Hi, and welcome to SF! In the future, this kind of additional info helps the most when edited into your original question, or posted as a comment after Doug's comment. – Kara Marfia Jul 20 '10 at 13:43
feedback
up vote 0 down vote

Stsadm will compress its backup by default - I believe using the -nofilecompression switch will give a file size closer to what you'd expect to see.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.