|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
.BAK extension ??
Usualy I do not use SQL server, but this time I have got some data to import. Data is on the CD, and it is named with extension .BAK. The organization I've got data from does not have true DBA at this moment, and I am not sure what I actualy got. The previous DBA resigned. I have requested dump of database structure only, but I could manage with full database dump, too. I am afraid that the file I've got is not either of those two. Currently I do not have SQL server installed. Could .BAK files be interchanged between different machines ? Could .BAK be an incremental backup ? Are they compatibile for different versions of SQL server ? Person that gave me the CD was not able to tell what version of SQL server are they running. DG ..BAK is the standard extension for a full backup. You'll have to have a
recent version of SQL Server to try and restore it. If it restores OK, you can extract the structure in the form of a script. -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinpub.com .. "Drazen Gemic" <any***@anywhere.tk> wrote in message Usualy I do not use SQL server, but this time I have got some data tonews:dv7haf$me7$1@magcargo.vodatel.hr... Hi ! import. Data is on the CD, and it is named with extension .BAK. The organization I've got data from does not have true DBA at this moment, and I am not sure what I actualy got. The previous DBA resigned. I have requested dump of database structure only, but I could manage with full database dump, too. I am afraid that the file I've got is not either of those two. Currently I do not have SQL server installed. Could .BAK files be interchanged between different machines ? Could .BAK be an incremental backup ? Are they compatibile for different versions of SQL server ? Person that gave me the CD was not able to tell what version of SQL server are they running. DG
Other interesting topics
Sql Server Resetting Ansi_Nulls Setting
SysAdmin and ServerAdmin unable to start/stop or pause services SQL Monitoring tools... Log Shipping Read only and access to specific databases Updating records in one table from another encrypting data in SQL table? Procedure to Stress Test DB question SP4 Install Hangs on Validating User Screen |
|||||||||||||||||||||||