Home > Archive > MS SQL Server > March 2006 > .BAK extension ??









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author .BAK extension ??
Drazen Gemic

2006-03-14, 8:23 pm

Hi !

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

Tom Moreau

2006-03-14, 8:23 pm

..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" <anyone@anywhere.tk> wrote in message
news:dv7haf$me7$1@ma
gcargo.vodatel.hr...
Hi !

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

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com