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
 SQL Server Development (2000)
 Shrink DB after port

Author  Topic 

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 2003-01-03 : 10:45:14
I just ported my database to a new design. How can I shrink/purge the new database of all its logs etc as to shrink it? The db is at 50 megs right now and I think its a tad bit to big.

What should I purge it off? i.e logs...what else?

(Scripts please)

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-03 : 10:48:47
http://www.sqlteam.com/SearchResults.asp?SearchTerms=shrink

Jay White
{0}
Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2003-01-04 : 01:43:04
quote:

I just ported my database to a new design. How can I shrink/purge the new database of all its logs etc as to shrink it? The db is at 50 megs right now and I think its a tad bit to big.

What should I purge it off? i.e logs...what else?

(Scripts please)






Detach the database
delete the logfile
attach the database back
this will create a new log file for u.
regards,
harshal.

Expect the UnExpected
Go to Top of Page
   

- Advertisement -