Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SMS SQL Database

Status
Not open for further replies.
GSC

GSC

MIS
Mar 27, 2001
464
EU
Hi,
I have created a fragmentation report on our SMS 2003 SQL 2000 Database. I found a lot of fragmented files in there and I'm thinking of performing a defragmentation.
Good or bad?
Something that I should consider before doing this?

Thanks,
GSC
 
Sort by date Sort by votes
Seems to me this was something I had to do on 2.0 sp4-5, it took forever but went well, Just make sure your backup is good. I also defragged the virtual mem drive if I recall this right. It did help quite a bit. I also believe I had them run at a reboot before windows loaded.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wmcalin
  • Locked
  • Question
SMS
Replies
0
Views
153
wmcalin
wmcalin
morefays
  • Locked
  • Question
SMS Server Slient Installation Issue
Replies
0
Views
154
morefays
morefays
joneed2nomo
  • Locked
  • Question
Can't load SMS client Software Update Point Client Installation
Replies
0
Views
165
joneed2nomo
joneed2nomo
MarkR800
  • Locked
  • Question
SMS cross-forest operation
Replies
0
Views
79
MarkR800
MarkR800
weeyin83
  • Locked
  • Question
SMS Exit Code 1?
Replies
2
Views
97
weeyin83
weeyin83

Part and Inventory Search

Sponsor

Back
Top