Database size

[enochsfootwear]

Hi,
I have a SQL database I’m using to develop as a back-end for an ASP project. There are about 60 tables, but since it’s only used for development there a just a few records in it. When I open Enterprise Manager and right click the database and do the properties on it reads about 3 gigs. I have the same database minus a few records at another location and it reads about 6mb. What could cause the database to be so big is it the transaction log?

Thanks

 

[SQLSister]

Let me guess, you havn't been backing up the transaction log?

Questions about posting. See faq183-874

 

[enochsfootwear]

No we haven't. My customer only recently decided they wanted to start back-ups. Should I delete the transaction log?

 

[NoCoolHandle]

Yep, then do a full back up in the next instant!
then start a full regime of backups via tran log and periodic tran logs or start a differential backup with tl's and full backups..

my 1c

Sister GOOD CALL!

I probably would have forgoten to check and had them run the sp_spaceused which might have given the clue. Again Nice job.

 

[enochsfootwear]

Ok,
Thanks everyone

 

[chrissie1]

3 gig's of transaction logs. at least they work hard.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[NoCoolHandle]