Data Generator Holds Connection to Database

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Data Generator Holds Connection to Database

Postby rodney » Thu Apr 04, 2013 7:21 am

I used data generator to generate some data, then wanted to restore my database to its original state. This requires exclusive access to the database, but it appears that the SQL Generator app holds its database connection, even if you close the project it still seems live until you close the whole application.

Closing and reopening the app is a work around, but is there something more obvious?

Thanks
rodney
 
Posts: 1
Joined: Thu Apr 04, 2013 7:11 am

Postby Chris Auckland » Fri Apr 05, 2013 11:57 am

Thanks for your post.

Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.

Are you restoring using native SQL or something else?

What does sp_who2 show you for the connection to the database you're trying to restore?
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests