Saturday, February 25, 2012

.mdf files

Hi,
I have 3 .mdf files on my system.
database.mdf (2 MB), database_1.mdf (450 MB), database_2.mdf (750 MB)
what does each file represent. If i have to take the backup of my
data(loga not required) then which file should i take.
Thanks
> what does each file represent. If i have to take the backup of my
> data(loga not required) then which file should i take.
Each file contains a portion of the database. You should backup the
database with BACKUP DATABASE rather than a file system backup. This will
backup all necessary data, including the transaction log, at consistent
state so that you can later RESTORE.
Hope this helps.
Dan Guzman
SQL Server MVP
"Gaurav" <gauravgoyal121@.gmail.com> wrote in message
news:1184326702.252930.117950@.n2g2000hse.googlegro ups.com...
> Hi,
> I have 3 .mdf files on my system.
> database.mdf (2 MB), database_1.mdf (450 MB), database_2.mdf (750 MB)
> what does each file represent. If i have to take the backup of my
> data(loga not required) then which file should i take.
> Thanks
>

No comments:

Post a Comment