it helps, but still have some questions

thank you, guys. Your reply really help me. Now, basicly, I'm clear about
these technical terms. But not sure the following questions:
1. How do I know whether my sql server is in Simple Mode or not?
2. Does the full database backup include the last lsn? I try to understand
how the system works. when I restore data using the full database backup
with a trans log backup, the system will firstly restore the data in the
full backup, next, it will take out the transactions from the trans log
backup that time is later than the last lsn, and do all these trans so that
all data can be restored.
3. My database is not big, I think it will under 2GB. I got a plan, but
don't know is't a good one. I will do a full backup 1 time per month, and
1 time differential database backup per day, and then 1 time trans backup
per hour. Is it suitable for me?
oh, I really sorry for my poor English, even me has been confused by my
words, but I've try my best. Hope you will know what I say. Here some recommendations:
1) Right-click your database and select Properties, then on Options look for
Recovery model.
2) For a database under 2GB, I would definitelly do a daily full backup,
perhaps at night, or when the number of transactions is low or minimum. If
this works fine for you, then you do not need a differential backup, only
transaction log backups in addition to the daily full backup.
Ben Nevarez, MCDBA, OCP
"mizi" <haha@.haha.com> wrote in message
news:Xns9718C5C08B547hahahahacom@.207.46.248.16...
> thank you, guys. Your reply really help me. Now, basicly, I'm clear about
> these technical terms. But not sure the following questions:
> 1. How do I know whether my sql server is in Simple Mode or not?
> 2. Does the full database backup include the last lsn? I try to understand
> how the system works. when I restore data using the full database backup
> with a trans log backup, the system will firstly restore the data in the
> full backup, next, it will take out the transactions from the trans log
> backup that time is later than the last lsn, and do all these trans so
> that
> all data can be restored.
> 3. My database is not big, I think it will under 2GB. I got a plan, but
> don't know is't a good one. I will do a full backup 1 time per month, and
> 1 time differential database backup per day, and then 1 time trans backup
> per hour. Is it suitable for me?
> oh, I really sorry for my poor English, even me has been confused by my
> words, but I've try my best. Hope you will know what I say.