[MS_AccessPros] MS SQL Server "BAK" bloated file size

 

Hi,

• 
  

  Although it's not MS-Access question but hopefully experts can still help.

  
  

  I created a backup file of my MS SQL 2012 ( not Express Edition ) database  on PC1.

  The file size of BAK file was 531MB.

  
  

  Then copied that BAK file on PC2 that had MS SQL 2012 Express Edition.

  Restored the database from the BAK file.

  
  

  Then immediately created BAK from that newly created DB on PC2.

  
  

  Surprisingly, the new BAK file size was 3GB. 

  
  

  Can someone please educate me why the newly BAK file is way too big?

  
  

  Ozair

__._,_.___

---

Posted by: ozairkhalid@hotmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___