seeing MDB size without restoring ?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

seeing MDB size without restoring ?

Postby johnbr1 » Fri Nov 15, 2013 4:36 pm

If I purchase, will I be able to open an .sqb file in the Microsoft restore gui and see the size of the LIVE .MDB file WITHOUT RESTORING like I can directly with a .bak file ?
johnbr1
 
Posts: 1
Joined: Fri Nov 15, 2013 4:24 pm

Postby petey » Mon Nov 18, 2013 6:46 am

You can use the SQL Backup GUI to see the database size e.g.

Image

You can also check the database size using Windows Explorer, as SQL Backup comes with an Explorer add-on e.g.

Image


Lastly, you can run the RESTORE SQBHEADERONLY command to check the database size e.g.

Image
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest