Hi All, I am getting following error message while splitting sharepoint content databases using stsadm mergecontentdb command. " The sqltransaction has completed; it is no longer usable " For Information: I am using SharePoint Server 2007 Enterprise with Service Pack 2 updated (Version: 12.0.6425.1000) and SQL Server 2005 Enterprise with Service Pack 3 updated. Also I have enough space on my DB server for my content databases. Any help in this regard will be greatly appreciated.

is their enough space availble on the drive,atleast three times the content db size. MergeContentDBs command as per the following KB Article: The STSADM MergeContentDBs command may cause database corruption in Windows SharePoint Services 3.0 http://support.microsoft.com/default.aspx/kb/969242 Article http://technet.microsoft.com/en-us/library/cc262923(office.12).aspx talks about the various options available with merge content database commands and I am sure you must have already explored the same . Also you have mentioned that the database is large around 378 GB its recomended that you consider using Batch Site Manager and the method that is described in the "Move site collections" topic on Microsoft TechNet. To do this, visit following Microsoft Web site: http://technet.microsoft.com/en-us/library/cc508854.aspx (http://technet.microsoft.com/en-us/library/cc508854.aspx) Because the Batch Site Manager works with site collections by using the STSADM backup and restore operations with the –url parameter, we recommend that you not use Batch Site Manager for site collections that are larger than 15 GB. Check article http://support.microsoft.com/default.aspx/kb/969242 Thanks -wsi am at SharePoint administrator

Dear Waqas, I have not mentioned that my content database is large around 378 GB ? Have your read my post properly ?