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’

 

0 (0)
Article Rating (No 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 backup MySQL on Attix5 Server Edition for Windows
    Viewed 3534 times since Fri, May 30, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 2226 times since Mon, Aug 17, 2015
    How to use Attix5 VirtualRestore
    Viewed 1120 times since Wed, May 28, 2014
    How to setup Attix5 VirtualRestore
    Viewed 2230 times since Wed, May 28, 2014
    How to perform a bare metal restore in Attix5
    Viewed 1788 times since Fri, Aug 14, 2015
    How to Setup Email Notifications
    Viewed 2215 times since Sat, Aug 15, 2015
    How to Restore Windows System State
    Viewed 2131 times since Sun, Aug 16, 2015
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 2133 times since Tue, Apr 12, 2016
    Enable VSS writer for Exchange 2003 servers
    Viewed 2686 times since Tue, Nov 11, 2014
    How to Backup Windows System State
    Viewed 1989 times since Sun, Aug 16, 2015