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 an Exchange server using the Attix5 VSS plugin
    Viewed 5201 times since Tue, Nov 4, 2014
    Enable VSS writer for Exchange 2003 servers
    Viewed 3956 times since Tue, Nov 11, 2014
    How to use Attix5 VirtualRestore
    Viewed 1123 times since Wed, May 28, 2014
    How to Backup Windows System State
    Viewed 2279 times since Sun, Aug 16, 2015
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 6846 times since Wed, Nov 12, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 2418 times since Mon, Aug 17, 2015
    How to restore a MS SQL database using the Attix5 VSS plug-in
    Viewed 4119 times since Wed, Nov 12, 2014
    How to Setup Email Notifications
    Viewed 2950 times since Sat, Aug 15, 2015
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 2493 times since Tue, Apr 12, 2016