I am using Veritas backup exec 10.d with sql agent. I am able to see the sql express studio 2005 database files but there is difference in file size between original database file and the one shows in sql agent backup selection. The backup performs 100% successful but the original database file size is different e.g( original file:350MB, backup file: 28MB)..
Any ideas...?
Thanks in advance..
Have you talked to the folks at Veritas/Symantec about this? They can probably give you better information about their software.
Regards,
Mike Wachal
SQL Express team
-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1
The SQL API that BE plugs into will only send extents that are currently allocated by the database, so if you have created a database with an initial size and not filled it, we'd expect this delta.
Beyond this, I'd check if compression is enabled.
Of course, the ultimate test of whether a backup is valid or not is to attempt to do a restore. This should be a periodic task for any backup setup.
No comments:
Post a Comment