Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 regarding Database size differ

Author  Topic 

suman.reddy39
Starting Member

34 Posts

Posted - 2008-09-23 : 01:05:14
Hi guys,
I need a small help. I have taken a backup for one of my databases. The size was 20mb and I have run some scripts on the existing database now when I took back up of this data base where I have run the scripts its size differ from the original one. It is showing 15mb only can any one let me know where I went wrong?


Don't go the way Life takes you, Take the Life the way you go

subbi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 01:27:23
what were type of scripts that were run?
Go to Top of Page

suman.reddy39
Starting Member

34 Posts

Posted - 2008-09-23 : 01:29:02
it was general scripts in which some update,insert and some create new table scripts were there.

Don't go the way Life takes you, Take the Life the way you go

subbi
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-23 : 08:43:05
You must have taken Differential backup or Tran log backup.
Go to Top of Page
   

- Advertisement -