Newsman Pro Forums
 

MS-SQL Database Maintenance question

 
Post new topic   Reply to topic    newsmanpro.com Forum Index : General Discussion
View previous topic :: View next topic  
Author Message
turbofish
Experienced
Experienced


Joined: 13 Dec 2004
Posts: 51
Location: 20 miles from now where
PostPosted: Thu Jun 07, 2012 8:55 pm    Post subject: MS-SQL Database Maintenance question Reply with quote
Not sure if I just never noticed it before but does it rebuild the indexes after it shrinks the database?
_________________
jeff fisher, MCP
www.turbofish.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
administrator
Developer
Developer


Joined: 24 Jul 2004
Posts: 4762
Location: King William, VA
PostPosted: Thu Jun 07, 2012 11:56 pm    Post subject: Reply with quote
It does a defrag. There are 2 new stored procedures that do all of the work:

[DBname].dbo.ShrinkDB
[DBName].dbo.DefragDB


Regards
Back to top
View user's profile Send private message Send e-mail
turbofish
Experienced
Experienced


Joined: 13 Dec 2004
Posts: 51
Location: 20 miles from now where
PostPosted: Fri Jun 08, 2012 4:04 am    Post subject: Reply with quote
Thanks - should have looked at the sprocs!
_________________
jeff fisher, MCP
www.turbofish.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    newsmanpro.com Forum Index : General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Copyright 2003-2006, Daniel Cumpian
NMP Default By ::Dementeddogz.com::