I have a SharePoint 3.0 Site Running on MS SQL 2005. I tried to move the site from C: to D: Using Detach and Attach and am not getting the following error...
An Exception Occurred While Executing a Transact-SQL statement or Batch
I need help with this ASAP...
Please respond with estimate of time, completion and cost...
Thank You!
We have 6 years of experience and 4 members.
We have done 20+ projects.
This failure may be due to the SQL version / size / Configuration issue of SQL.
If not we can move your site using stsadm commands.
Hi. The error is occurring in detach or when you attaching the new file?
I can check it right now.
The completion time is 10 min + copy file time.
Thanks
It will require to investigate the cause of the error.
Since its an environment specific issue, it will require me to login to the environment and the details of the steps that were followed while attaching/detaching to the DBs.