troubleshooting Question

When I go to restore a remote SQL Server 2005 database using Backup Exec 11d, the backed up database file is way too small.

Avatar of cpadm
cpadmFlag for Israel asked on
Storage SoftwareMicrosoft SQL Server 2005
8 Comments1 Solution840 ViewsLast Modified:
I have 2 Windows 2003 servers running SQL Server 2005 Std. I have BackupExec 11d installed on Server1 of the servers, and have purchased a remote BackupExec agent (for Server2) and an SQL backup plugin for BackupExec.

I run a full Backup of all data every night. If I go to restore any of the client databases, the file size is way too small - I have 2 very large databases, both over 200GB, yet when I set up a restore job in BackupExec, it sees these databases as approximately 2GB in size. I have the MS SQL backup job properties set to "Full, Backup entire database or filegroup". The backup jobs complete successfully every night.

I tried running a restore in the hope that database will amazing expand to it's proper disk size, but no luck. Is it possible that BackupExec has compressed the database file when backing it up? This is seriously worrying me that BackupExec is inexplicably not backing up our client databases...
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros