Content of Backup File

Question

Post reply

Content of Backup File

skrilla99

SSCertifiable

Points: 5795
More actions
August 23, 2005 at 11:13 am

#164872

Hi all,
I was just looking through a backup file created by SQL Server using the EM Wizard and noticed that along with myriad text data regarding the particular database that I backed up, it also includes at least two references to the first database (alphabetically) listed in EM/Databases.
Does anyone know where I can read more about the structure of these backup files, or know offhand why this other database name would be referenced in the backup file?
Sincerely,
Dan B

Viewing 8 posts - 1 through 7 (of 7 total)

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

homebrew01 SSC Guru Points: 55548 More actions · Answer 1

Not quite sure what you mean by " ... looking through a backup file ... "

You're reading the .BAK file somehow ?

skrilla99 SSCertifiable Points: 5795 More actions · Answer 2

Yeah.

Take a backup file, preferably a small one, open it in notepad and have a look around. There is a lot of the jumbled mess you might expect, but also a fair amount of plain text.

-Dan B

skrilla99 SSCertifiable Points: 5795 More actions · Answer 3

A little past a place where there is CollationID, there is a password field of some kind... GPASSWORD

I wonder if this is the password or mediapassword option when calling BACKUP via tsql...?

-Dan

sushila SSC-Dedicated Points: 35293 More actions · Answer 4

this link is specifically for homebrew01 (you don't actually have a "still" by your shed in the backyard do you..

backup files can be viewed

**ASCII stupid question, get a stupid ANSI !!!**

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

Thanks for the link !!

I don't have a "still" out in the yard, sorry 🙁 I just make beer, so I only need a big brewing pot and nice big fermenter (I use 7 gal glass bottles). Getting thirsty just thinking about a nice fresh India Pale Ale.

sushila SSC-Dedicated Points: 35293 More actions · Answer 6

I just make beer, so I only need a big brewing pot and nice big fermenter (I use 7 gal glass bottles). Getting thirsty just thinking about a nice fresh India Pale Ale...

LOL...didn't realize that your ssc name wasn't just a facade or wishful thinking..

btw - how does the homebrew compare against the India Pale Ale...or are you biased because it's "your baby" so can't give an objective opinion ?!

**ASCII stupid question, get a stupid ANSI !!!**

homebrew01 SSC Guru Points: 55548 More actions · Answer 7

I've made some very good beers (all different styles), and I've made some that I freely admit weren't very good. I think home brewers tend to view their first few as better than they really are. But I'm a pretty tough critic (of mine & commercial beer), so I didn't fool myself for long.