Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MS SQL Server Restore

  • 16-11-2005 1:21pm
    #1
    BlueSpud
    Registered Users, Registered Users 2 Posts: 302 ✭✭


    I have been given a backup of an MS SQL 2000 database, as the physical file generated by a SQL Backup into the ////backup folder (a .BAK file), as distinct from a bakup of the detatched dababase (the .MDF and .LDF files). I do not already have this database on my system and am at pains to know if I can retrieve it from the .BAK file, and if so, how.


Comments

  • #2
    optiplexgx270
    Registered Users, Registered Users 2 Posts: 2,523 ✭✭✭optiplexgx270


    BlueSpud wrote:
    I have been given a backup of an MS SQL 2000 database, as the physical file generated by a SQL Backup into the ////backup folder (a .BAK file), as distinct from a bakup of the detatched dababase (the .MDF and .LDF files). I do not already have this database on my system and am at pains to know if I can retrieve it from the .BAK file, and if so, how.

    create a new DB with the same name and in enterprise manager restore from file. and select the locations of the data and transaction logs.


  • #3
    BlueSpud
    Registered Users, Registered Users 2 Posts: 302 ✭✭BlueSpud


    Ah, your'e a good lad, worked a tread. Thanks.


Advertisement