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 Setup Email Notifications
    Viewed 3128 times since Sat, Aug 15, 2015
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 5353 times since Fri, May 30, 2014
    How to restore a MS SQL database using the Attix5 VSS plug-in
    Viewed 4271 times since Wed, Nov 12, 2014
    How to perform a bare metal restore in Attix5
    Viewed 2101 times since Fri, Aug 14, 2015
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 4750 times since Wed, Nov 5, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 2542 times since Mon, Aug 17, 2015
    How to Restore Windows System State
    Viewed 2901 times since Sun, Aug 16, 2015
    Configure SQL 2005 & 2008 Express for Attix5 SQL Plugin
    Viewed 2378 times since Fri, May 16, 2014
    Enable VSS writer for Exchange 2003 servers
    Viewed 4351 times since Tue, Nov 11, 2014