restore data base contains the previous connections

  • hi

    i took back up from the server and i have restore it in my local machine

    in source for restore --> from device --> i browse the back up file

    here when i click on add button

    in select the back ups sets to restore : option i got is my server connections (server path)

    how can i get my local system connection like D:ewfolder\sample.back

    thanks

    nagaraj

  • If you are on the Server Instance and trying to restore, then you will get the drives on the server.

    If you are on the Local Instance (your system) and trying to restore, then you will get the drives on your system.

    Copy the backup file on your system and connect to the local instance from SSMS.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • can u please give me the procedure to be followed in ssms

    thanks

    nagaraj

  • Here it is

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply