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.
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=shrinkJay White{0} |
|
|
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 databasedelete the logfile attach the database backthis will create a new log file for u.regards,harshal.Expect the UnExpected |
|
|
|
|
|