locked
To find out the path RRS feed

  • Question

  • RESTORE DATABASE NewAbitaDB
       FROM DISK = 'c:\7augbkup.bak' WITH REPLACE,

    here, instead of "c:\" it has to take the current path that means where i loaded the backup file, how to find out?

    Wednesday, August 16, 2006 5:45 AM

Answers

  • If you want to make a file restore (like mentioned above) you will have to know and specify the path where the backup is located. Be aware that the absolute path syntax of SQL Server is always specifying the local drives on the server *not* on the client.

    HTH, Jens SUessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, August 16, 2006 7:13 AM