compare mdf for success restore of data and file storage

20 Oct 2005 9:48 PM

Ram

Gurus,
I have a scenario where in if i restore a database file(mdf) onto
say some AppManager,i want to make sure its restored properly comparing with
the mdf that it came from(i take this as base).i hope iam making sense here.

20 Oct 2005 9:53 PM

Ram

Can we do this programmatically?Any ideas are really appreciated.

Show quote

"Ram" wrote:

> Gurus,
> I have a scenario where in if i restore a database file(mdf) onto
> say some AppManager,i want to make sure its restored properly comparing with
> the mdf that it came from(i take this as base).i hope iam making sense here.

20 Oct 2005 10:09 PM

Jerry Spivey

Ram,

Restore of a backup (.bak) or an attach of a data file (.mdf)? If the
latter do you have the log file as well? If so the database will resolve to
the same schema and data as the database was when it was detached.

HTH

Jerry
Show quote

"Ram" <R**@discussions.microsoft.com> wrote in message
news:4D3E6347-DCCE-49C4-A1DD-B14D0596AB82@microsoft.com...
> Gurus,
> I have a scenario where in if i restore a database file(mdf)
> onto
> say some AppManager,i want to make sure its restored properly comparing
> with
> the mdf that it came from(i take this as base).i hope iam making sense
> here.

21 Oct 2005 1:46 PM

Ram

Thanks Jerry,
Actually backup file contains the folders database(mdf and logfile) and the
file store.

Ram
Show quote

"Jerry Spivey" wrote:

> Ram,
>
> Restore of a backup (.bak) or an attach of a data file (.mdf)? If the
> latter do you have the log file as well? If so the database will resolve to
> the same schema and data as the database was when it was detached.
>
> HTH
>
> Jerry
> "Ram" <R**@discussions.microsoft.com> wrote in message
> news:4D3E6347-DCCE-49C4-A1DD-B14D0596AB82@microsoft.com...
> > Gurus,
> > I have a scenario where in if i restore a database file(mdf)
> > onto
> > say some AppManager,i want to make sure its restored properly comparing
> > with
> > the mdf that it came from(i take this as base).i hope iam making sense
> > here.
>
>
>

21 Oct 2005 1:55 PM

Ram

Jerry,
Back up file has an extension of _dbbak which is compressed and contains
both mdf and ldf files.

Show quote

"Jerry Spivey" wrote:

> Ram,
>
> Restore of a backup (.bak) or an attach of a data file (.mdf)? If the
> latter do you have the log file as well? If so the database will resolve to
> the same schema and data as the database was when it was detached.
>
> HTH
>
> Jerry
> "Ram" <R**@discussions.microsoft.com> wrote in message
> news:4D3E6347-DCCE-49C4-A1DD-B14D0596AB82@microsoft.com...
> > Gurus,
> > I have a scenario where in if i restore a database file(mdf)
> > onto
> > say some AppManager,i want to make sure its restored properly comparing
> > with
> > the mdf that it came from(i take this as base).i hope iam making sense
> > here.
>
>
>

21 Oct 2005 4:43 PM

Jerry Spivey

Ram,

Compressed? Try decompressing the .mdf and .ldf files then copy them to the
location(s) where you store your .mdf and .ldf files. Then use sp_attach_db
to associate the database with SQL Server.

HTH

Jerry
Show quote

"Ram" <R**@discussions.microsoft.com> wrote in message
news:A4A34557-DEAA-4E69-81B6-5085E78C0830@microsoft.com...
> Jerry,
> Back up file has an extension of _dbbak which is compressed and contains
> both mdf and ldf files.
>
> "Jerry Spivey" wrote:
>
>> Ram,
>>
>> Restore of a backup (.bak) or an attach of a data file (.mdf)? If the
>> latter do you have the log file as well? If so the database will resolve
>> to
>> the same schema and data as the database was when it was detached.
>>
>> HTH
>>
>> Jerry
>> "Ram" <R**@discussions.microsoft.com> wrote in message
>> news:4D3E6347-DCCE-49C4-A1DD-B14D0596AB82@microsoft.com...
>> > Gurus,
>> > I have a scenario where in if i restore a database file(mdf)
>> > onto
>> > say some AppManager,i want to make sure its restored properly comparing
>> > with
>> > the mdf that it came from(i take this as base).i hope iam making sense
>> > here.
>>
>>
>>