After installing the pre-requisites a restart of the server may be required.
If you proceed without restarting then setup may be unable to proceed when it detects the pending restart.
It sounds like you have 3 Wide IPs set up on the GTM, which will also answer requests for records in the zone you wish to transfer.
Recently I faced this issue with SQL 2008 R2 and the below solution worked for me: 1) Create a new database with the same name as the one you are trying to restore 2) While restoring, use the same name you used above and in the options, click the overwrite option You might give the above a shot if the other solutions don't work.
The backup creator had MSSql version 10 installed, so when he took the backup it also stores the original file path (to be able to restore it in same location), but I had version 11, so it could not find the destination directory.
Sql Error: The operating system returned the error '5(Access is denied.)' while attempting 'Restore Container:: Validate Target For Creation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data Lab Tables.mdf'. It turns out all I had to do was tick the box marked 'Relocate all files to folder' on the 'Files' section: (Click to see image full size) This of course assumes you have the correct version of SQL Server installed. That sounds like: a) that file already exists (because you've already restored it previously) and is in use by SQL Server or b) that directory doesn't exist at all In your question, you mentioned you created a backup for that table - that's not how SQL Server backups work.
command fails if the file exists, even if it isn't in use by SQL Server (eg the MDF/LDF files remain in place after a previous detach).
The error comes when I am trying to add the name server to be part of the list of servers in a zone. I have a case open w/ MS but I am hoping to save $$$ and time on this. As it has been explained to me he is trying to transfer one of our DNS zones to the GTM in addition to our DCs (w/ DNS).