How to restore SQL database files with a .DAT extension in Attix5

Some older SQL servers created a *.DAT file when backing up the SQL databases. SQL unfortunately does not recognise the .DAT extension as a valid backup file so you need to extract the database from this file.

  1. First restore the .DAT file in Attix5 Server Edition to a temporary location eg: C:\TempFolder\MyDatabase.dat.
  2. Next you need to confirm what the .DAT file contain. To do this run the following command in SQL:

    RESTORE FILELISTONLY FROM DISK=’C:\TempFolder\MyDatabase.dat’ 


    This will return a result similar to the info below confirming the .DAT file contains the database files you want to restore:

    LogicalName :: PhysicalName :: FileGroupName

    Data_V2_1_Data :: C:DATABASESMyDatabase.MDF :: PRIMARY
    Data_V2_1_Log :: C:DATABASES\MyDatabase.LDF :: NULL

  3. You can now execute a RESTORE with the desired MOVE options:

    RESTORE MyDatabase
    FROM DISK=’C:\MyDatabase.dat’
    WITH
    MOVE ’MyDatabase’ TO ’C:\DBDataFiles\MyDatabase.mdf’,
    MOVE ’MyDatabase_Log’ TO ’C:\DBDataFiles\MyDatabase_Log.ldf’

 

5 (1)
Article Rating (1 Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Comments
    There are no comments for this article. Be the first to post a comment.
    Name
    Email
    Security Code Security Code
    Related Articles RSS Feed
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 4869 times since Wed, Nov 5, 2014
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 7202 times since Wed, Nov 12, 2014
    How to Setup Email Notifications
    Viewed 3294 times since Sat, Aug 15, 2015
    How to Restore Windows System State
    Viewed 3246 times since Sun, Aug 16, 2015
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 5553 times since Tue, Nov 4, 2014
    How to restore a MS SQL database using the Attix5 VSS plug-in
    Viewed 4421 times since Wed, Nov 12, 2014
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 5065 times since Tue, Apr 12, 2016
    How to Backup Windows System State
    Viewed 3123 times since Sun, Aug 16, 2015
    How to configure the MS SQL Attix5 Pro Plugin
    Viewed 6177 times since Fri, May 16, 2014