title: Copy SQL Server database between two servers
body: <p>I have a productive SQL Server database on one server. Also on this server there are the databases for test and development, which was over a long period no big deal for performance. But now I have to test some quite expensive selects for a nightly report and so my users get heavy trouble using the database during working hours.</p>
  <p>We have a redundant server with SQL Server running which we never really used, but now we think his time has come. Until now, to get a fresh copy of the production system I do a full backup, copy it into a folder on Server A and connect the folder as network drive an Server B. Then I copy the file into a folder where SQL Server has read permissions and import the backup into the database on B.</p>
  <p>On Server A I have made some maintenance plans for backing up the production system into one of the other systems by executing the plan.</p>
  <p>I want some solution like this for my B Server, but it doesn't seem to get running. I can do a Select from server A in a table on server B, so they both do know each other and can see them.</p>
  <p>I've tried the copy database wizard but it crashes because it couldn't delete the database on server B even if I had removed it manually before the try.</p>
  <p>I also tried importing the Database on Server B from Server A but it didn't work either.</p>
  <p>Googling my problem didn't work out because I always get solutions to the problem making backup files onto some kind of server.</p>
  <p>Hope someone of you could help automating this process.</p>