none
Unable to restore DB to local machine since server move RRS feed

  • Question

  • Since moving my website and database to ionis 1 and 1 server, trying to verify and restore backups using SSMS on my local machine fails. 

    I have also tried repeating the exercise with a blank DB with the same results.

    What should I be looking for to resolve this?

    The remote server is using SSMS 17 and my local machine is SSMS 14

    Monday, May 20, 2019 7:14 AM

All replies

  • So you can take the backup but there is some error when you try to restore it?
    Monday, May 20, 2019 9:03 AM
  • Hi querydave,

    Welcome to SQL ServerTransact-SQL.

     

    Per your description, I am afraid that I could not understand your issue clearly. Could you please share us your operation steps and error message ? So that we could have a right direction .

     

    There is an article about Restore a Database to a New Location (SQL Server), please refer to it.

     

    If you have any question , please let me know.

     

    Best Regards,

    Rachel


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, May 21, 2019 3:00 AM