Ron - Monday, December 20, 2010 12:17 PM:
Hi
I have two databases, one InnovatorSolutions as the live system, the other was created as a test raining enviroment. I would like the Test database to be a copy of the live system. using MS SQL Studio, I created a backup of the Live system, then selecting the test database I try to restore from the live backup. No matter how I try I am getting
It is being used by database 'InnovatorSolutions'. (Microsoft.SqlServer.Smo).
Backgroud info. The Live system and test database are both on the same SQL express 2005. I have two other computers that I have been using for development, both running Express 2008, one is 64bit the other is 32bit. Both computers I have installed Innovator with two databases and in both cases I am able to restore using the backup created from the live system.
On one systen I installed Innovator with one default database, restored using the live database, I was able to login and everthing looks fine. I then created a second database called TestInnovator, Using SQL studio 2008 I created a backup of the default database, then using this backup I was able to do what I wanted on the live system, I was able to restore and it works fine.
Sooo Why using Express 2005 on the live system, I can not restore to the Test database.
Any help would be greatly appreciated
Ron
Brian - Wednesday, December 22, 2010 5:17 PM:
Hi Ron,
Not sure I can help except to say that I have several databases running under SQL 2005 Express on the same machine and I have never encountered this problem.
You could try creating a new database with SQL Mgt and then restore to it rather than the existing Test database.
Failing that you might need to stop the IIS Server to ensure that the database is not being accessed from an unusual location.
Cheers,
Brian.
