If you don't have any complete database backup, it is impossible to restore database from just .ldf.

Robert

When do you do the complete database backup?

You should do it everyday. If you don't do this backup for a long time then the diff backup would be very...

Thank you guys.

My database got about 20 connections/second.

Does it still work?

I start sql with single user mode from cmd.

then restore from backup.

Thanks again.

...

Thank you again, Frank. I changed the registration.

Robert

Thank you very much, Frank.

Robert

please give me full statement. Thanks!

Robert

If you don't backup trans log file, go to EM

database-proterty-option-recovery mode, select simple. Then the trans log file will be truncated and shrinked automatically. If you want to back up...

I think so. You can try it, truncate is very fast. shrink will take much longer time. but for your database only a few GB, it wouldn't take too long...

After optimizing every Sunday, my database becomes very large(both .mdf and .ldf files).

I did the following steps to shrink the database. It works everytime (nearly one year).

1. run dbcc shrinkdatabase(dbname,...

Simply right click on the job, click property, select schedule, click edit, then select the schedule you want, monthly, daily, or just once, whatever you want.

Robert

You can run profiler or check in current activity to catch the application which causes the blocking. The long query would take lots of resources. The query with many joins...

Allen is right. Similar situation happened to our main sql server. Once we run a new application all the time on the server. The memory leaks. I must reboot the...

check out the database option recovery model

is full instead of simple.

Robert

Thanks Rajes, I will follow your idea.

Robert

I agree. If he chooses auto create statistics and auto update statistics in database option, will this work? To me this doesn't work. Could you explain why not.

Thanks!

Robert

...