We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Reorganizing MSSQL by doing an export-import

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Mischa van Dinter
on Jul 12 at 3:05 AM 		Mark this reply as helpfulMark as helpful
Hi David and Jack,

Thank you for your replies. I remember reading about the reorg not being neccesary, I am happy to see it confirmed. It would save me a lot of time and effort to not do it. Actually the size of the database is not even an issue, it is really just about the performance.

I will take it up again with our customer. Perhaps a closer look at the indexes is required.

Best regards,
Mischa van Dinter





---------------Original Message---------------
From: Mischa van Dinter
Sent: Friday, July 09, 2010 7:35 AM
Subject: Reorganizing MSSQL by doing an export-import

> Hi,
>
> We are cleaning up a customer's MSSQL 2005 database (deleting old clients etc) and it has been suggested to me (by an Oracle specialist) to reorganize the MSSQL database by exporting and importing it using the SAP installation tools. This would allegedly defragment the database, free up space and increase performance. However I have always thought MSSQL does not need this kind of reorganization.
>
> My question: would a procedure like this do my MSSQL database any good or is it a waste of time? Would there be a better way to reorganize this database that would not mean essentially reinstalling SAP?
>
> Thanks,
> Mischa van Dinter

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language