Post reply

i am trying to do a restore to a database from a file .bak which is located to a different server

  • March 6, 2006 at 7:15 am

    #90851

     

    hello friends, you know i am trying to do a restore to a database from a file .bak which is located to a different server , that is visible in my local net, my problem that the path from the external server is not visible in the window of enterprise manager to do the restore from .bak, only it shows the local directory c:/, is posible to search some path of a file of my local net using the enterprise manager?

    thank you for read me, sorry my bad english

  • March 6, 2006 at 7:48 am

    #624876

    you won't be able to do this via EM - use the unc to restore over the network..

    restore database dbName
from disk = '\\serverName\shareName\dbBackup.bak'







    **ASCII stupid question, get a stupid ANSI !!!**

  • March 6, 2006 at 8:03 am

    #624922

    Sorry my ignorance what is unc?

    do you refer to the query analizer ? to do it using tsql?  thanks...........

  • March 6, 2006 at 8:11 am

    #624925

    yes - do this in query analyzer using the t-sql statement "restore database etc....."

    unc stands for "uniform naming convention" and provides a unique address on a local network..







    **ASCII stupid question, get a stupid ANSI !!!**

  • March 6, 2006 at 8:25 am

    #624928

    Thanks, today i learned a new word thanks my friend

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

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