Results 1 to 4 of 4

Thread: problemas with SQLSERVER 7.0

  1. 08-21-2003, 09:29 AM #1
    isacas69
    isacas69 is offline Registered User
    Join Date
    Aug 2003
    Location
    Cali - Colombia
    Posts
    2

    problemas with SQLSERVER 7.0

    hi.

    How i can recover a Database in SQLSERVER 7.0 in another server, if i have ONLY the .DAT files?

    There are not backups...

    Please help me... thanks.
    Reply With Quote Reply With Quote
  2. 08-21-2003, 09:57 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://forums.databasejournal.com/sh...threadid=32941

    sp_attach_db
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 08-21-2003, 11:39 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Is .dat file really your database data file? Where do you get it? It maybe db backup file.
    Reply With Quote Reply With Quote
  4. 08-21-2003, 12:57 PM #4
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can run

    RESTORE HEADERONLY
    FROM DISK='c:\yourfile.dat'

    If it is a backup file you will see details about the backup, if not you will see an error.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules