Attaching a database

Question

Attaching a database

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Frank Cazabon Hall of Fame Points: 3467 More actions · Answer 1

It turns out the .DAT file was actually a backup so restoring it worked. I n=guess older versions of SQL Server created .DAT files instead of .BAK files.

Robert Davis One Orange Chip Points: 28027 More actions · Answer 2

When you create a backup, you can give it any extension you want .... which is what they did. It's not because it is an older version.

My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

Frank Cazabon Hall of Fame Points: 3467 More actions · Answer 3

Frank Cazabon

Hall of Fame

Points: 3467

December 1, 2006 at 5:13 am

#675110

Thanks.

D Gillespie Old Hand Points: 387 More actions · Answer 4

The .DAT file extension is also the default for SQL 6.5 database and backup files. Probably not a good thing to name your SQL 7/2000 backup files with an extension that was used in a previous version of SQL Server?

MohammedU SSCoach Points: 19644 More actions · Answer 5

As Robert mentioned you can give any extesion to it.

When you get the backup file from some one else, it is always better to run RESTORE HEADERONLY command to check file is sql backup or not?

MohammedU
Microsoft SQL Server MVP