V5 Frequently Asked Questions
Search:     Advanced search
Browse by category:

KB269: How to restore SQL database files with a .DAT extension

Views: 1792
Votes: 0
Posted: 09 Sep, 2010
by: Van Rensburg J.
Updated: 09 Sep, 2010
by: Van Rensburg J.
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 Server Edition to a temporary location eg: C:\Temp\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:\Temp\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'
Others in this Category
document KB003 - How do I increase the Virtual Memory for SE on a Novell NetWare server?
document KB005 - How to change the default service port
document KB016: Server Edition on Novell NetWare installation tips
document KB020: Server Edition memory on Linux
document KB022: Changing the default allocated memory in Windows SE for V5.x and older
document KB024: Server Edition service won't start
document KB025: How to export the SE display from Linux to Windows Desktop (Xming or Cygwin)
document KB028: Backing up mapped drives with Server Edition
document KB032: Run Server Edition in debug mode
document KB036: ddraw.dll problem
document KB045: What to do with incomplete log files
document KB049: Windows NT Server rasman.dll error
document KB050: Manual dialup on Server Edition using script plugin
document KB051: Error when upgrading SE: 'Could not create file SERunner.exe'
document KB053: Backup encrypted files
document KB056: Disable SERunner (system tray icon)
document KB065: CRC errors on FileServer / file length zero after write
document KB066: Problem with SMSUT.NLM
document KB068: Upgrade Server Edition on Novell NetWare
document KB069: Negative dates during restore
document KB073: UNC for Windows and NetWare
document KB074: Server Edition Access Security
document KB078: Skipped Files: "The system cannot find the path specified"
document KB080: Database Locked errors
document KB083: Backing up network volumes
document KB084: What do the Processor Usage and Disk Access sliders in SE mean?
document KB089: Could not create backup: The device is not ready
document KB109: VSS and Long Filenames
document KB113: Install tips for LINUX platforms
document KB114: SE v4.1.16 does not auto-update
document KB122: "Could not create Java virtual machine"
document KB123: TSJNI.NLM NetWare restore error message
document KB125: NetWare client trying to access \etc
document KB129: Conflict between actual Backup Size and Size function in GUI
document KB133: Unable to install SE after system state restore
document KB135: Clearing of cache in SE on WinXP is slow
document KB138: SCO libnio.so linker problem, service dies on backup
document KB163: Server Edition on Unix and SAMBA - skipped files
document KB180: Out of memory problems during delta blocking
document KB183: Auto-upgrade SE V5.0.0.199 / V5.0.1.1 to V5.0.2.8
document KB184: Manually upgrade SE V5.0.x to V5.0.2.8
document KB188: Cache update problem with Exchange 2007 and Exchange plugin
document KB189: How to recover a single Exchange 2003 mailbox without using the Exchange or SMR plug-ins
document KB192: Insufficient system resources exist to complete the requested service
document KB194: SMR gives 'Invoke of: GetObject' error during backup after upgrade to v5
document KB196: 64bit Linux failed dependencies: rtld(GNU_HASH)
document KB197: Email Notification fails to send test message with v5 SE.
document KB199: VSS Restores always overwrites original data
document KB215: VSS problems on V5 SE and Windows Server 2003 (mostly cache related)
document KB230: Run the SE or D&L GUI in test mode
document KB236: SQL backup fails with warning "A parallel operation cannot be started from a DAC connection."
document KB237: How to recover a single Exchange 2007 mailbox using Recovery Storage Group
document KB243: Large Exchange patches when delta blocking is used
document KB256: Unable to open Options in Server Edition
document KB267: Backing Up a MySQL Database using Attix5 Backup Professional SE and scripting



RSS