Viewing 11 posts - 1 through 11 (of 11 total)
May 4, 2017 at 8:59 am
Thanks for the recommendation. I was already heading in that direction and just wanted some confirmation that it was the best approach. Windows 10 lets me just install the hyper-v...
August 31, 2016 at 11:34 am
Thanks Gila, and thanks Jeff. I didn't get initial replies here so I researched it further and found the indications to execute the restore database <Name> with recovery, as...
August 16, 2016 at 11:35 am
Thanks Hugo.
I have this working via manual scripting, without using the wizard(s). I was unable to get the wizard to create the tables with the identity column and insert...
January 20, 2016 at 1:00 pm
Thanks! You’re correct, they are different in this respect. Column UID on Database EC on vm2 does not have the Identity property, whereas Column UID on database EC on vm1...
January 19, 2016 at 12:59 pm
GilaMonster (12/23/2015)
itguy2015 (12/22/2015)
I prefer to have the cancel run to completion and have mydb on vm2 remain as it was before I started the restore.
You could leave it from now...
December 23, 2015 at 8:17 am
I have a similar situation. I had a database "mydb" on a sql server instance on vm1. I also had mydb on a sql server instance on vm2....
December 22, 2015 at 2:50 pm
mark.williams 37494 (11/18/2015)
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
forgot the attachments on last...
November 18, 2015 at 9:40 am
mark.williams 37494 (11/18/2015)
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
I went to the network...
November 18, 2015 at 9:39 am
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.
Here is a screen shot of the services. Note that where I refer...
November 18, 2015 at 9:20 am
joeroshan (11/18/2015)
What do you see when you execute select @@servername from both the instances. I think they both pointing to same instance.Edit: I mean some alias name
servername ...
November 18, 2015 at 9:12 am
Viewing 11 posts - 1 through 11 (of 11 total)