On Thu, Jan 22, 2009 at 9:12 AM, Les Mikesell <lesmikesell AT gmail DOT com>
wrote:
> Nick Smith wrote:
>>
>> in the host summary under that backup client, the "new files" says
>> size 4427.8 comp/mb 777.0 comp 82.5%
>> thats a heck of a compression ratio. i know that sql dbs can compress
>> down nicely, but im comparing to the old
>> server and its not the same. the first full backup on the old server
>> was size 13119.9 comp/mb 6248.3 comp 52.4%
>> and nothing has changed on the client machine.
>>
>> so something isnt doing right. and the fact that when i restore one
>> of their large db files its only 768kb instead of the 5.6gb its
>> suppose to be.
>>
>> Where can i start to look and see what the problem was? ive checked
>> the logs on the server and client and there are no errors,
>> the backup says it completed successfully. what else can i do/check?
>> this has really got me worried.
>
> Is this marked as a partial - perhaps it didn't really complete. Look
> through the errorlog to see if the database file is mentioned. Also, is
> this a live, changing database file or a dumped copy? If it is live, a
> restored copy isn't likely to work anyway.
>
> --
> Les Mikesell
> lesmikesell AT gmail DOT com
It looks like it actually did fail, but the web interface said it
completed as was green
MSSQL7/Data/sw_exch_Log.LDF got digests
c586c1b3df5ef4140a5b1c248765e05c vs c586c1b3df5ef4140a5b1c248765e05c
create 644 400/401 1048576 MSSQL7/Data/sw_exch_Log.LDF
attribSet: dir=fthddb/MSSQL7/Data exists
attribSet(dir=fthddb/MSSQL7/Data, file=sw_exch_Log.LDF, size=1048576,
placeholder=)
Read EOF:
Tried again: got 0 bytes
Got done from child
Got stats: 769 16744448 0 0 ('errorCnt' => 0,'ExistFileSize' =>
93365724,'ExistFileCnt' => 25,'TotalFileCnt' => 31,'ExistFileCompSize'
=> 16058575,'TotalFileSize' => '4736263644')
finish: removing in-process file MSSQL7/Data/sw_image_Data.MDF
attribWrite(dir=fthddb/MSSQL7/Data) ->
/var/lib/backuppc/pc/thddb/new/fthddb/fMSSQL7/fData/attrib
attribWrite(dir=fthddb/MSSQL7) ->
/var/lib/backuppc/pc/thddb/new/fthddb/fMSSQL7/attrib
attribWrite(dir=fthddb) -> /var/lib/backuppc/pc/thddb/new/fthddb/attrib
attribWrite(dir=) -> /var/lib/backuppc/pc/thddb/new//attrib
Child is aborting
Got exit from child
Done: 31 files, 4736263644 bytes
Executing DumpPostUserCmd: /etc/backuppc/postusercmd-thddb.sh thddb
Rsync and shadow copy unloaded
Im using volume shadow to back up the databases, so they are not live.
(or in use)
I restarted another full backup to see if it completes this time. Ive
just never seen it say it completed when it really didnt.
the "sw_image_Data.MDF" referenced is the large DB file that had the
way smaller size, which was because it didnt complete
the backup.
Hopefully the next full will work.
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
|