I backed up the master database from one server after I had detached the model database. I then restored this master backup to a new server and now I do not have a model database referenced in master on this new server. I have the .mdf and .ldf files for the model database and I have tried creating a model database on the new server using these files with the create database and for attach statements, but I keep getting an error saying I can't do this because I don't have an exclusive lock on the Model database. How can I get the model database attached on this new server? (I am trying to avoid rebuilding then restoring master).
Any help is appreciated. Thanks.
Any help is appreciated. Thanks.