What are the challenges you face when working across database platforms? Take the survey

Data Generator Holds Connection to Database

rodneyrodney Posts: 2
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?



  • Options
    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?
Sign In or Register to comment.