XCopy not Detaching Database
- From: "Ken Hanson" <khanson@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Feb 2008 15:39:13 -0800
I am using the AttachDBFileName and User Instance properties to cause my ..mdf database to dynamicaly attach and detach when the application runs and stops execution. This is known as Xcopy Deployment, a very cool idea available only in SQL Express.
It all works perfectly both with and without User Instancing, up until I stop the application. The problem is that the .mdf file is never detached, also if I use user instancing the user instance sqlserv.exe process never stops, even when I set the user instance timeout to 5.
Any ideas or suggestions?
Best Regards,
Ken Hanson
.
- Prev by Date: Re: Failure Audit Event ID: 18456 SQL Server Error
- Next by Date: Re: Machine x receives results meant for machine y
- Previous by thread: RE: Machine x receives results meant for machine y
- Next by thread: Re: SQL Server 2000 License Question
- Index(es):