.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.googlegroups.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
>