Check whether if the database is in full recovery model.

Then take log backup.

eg: BACKUP LOG [DBA] TO DISK = N'C:\DBA_log_090909.trn'

Take new query window and select particular database...

Just have a look at the SQL server Logs

Check whether the instance name is given correctly

What is your need for that?

:-P:w00t:;-):-D:cool::hehe:

No 😀

The LocalSystem account is a predefined local account used by the service control manager. This account is not recognized by the security subsystem, so you cannot specify its name in...

hi,

the fillfactor effect specifies the percentage of space filled on index data pages when an index is initially created. The default fillfactor setting of zero, which can be altered at...

***** 😀 😛

Editor's Note: I'm not sure what this means, but I suspect it is a non-English, non-appropriate language, so I have removed it.

Any other chances for getting the time out error to happen

Thanks dude...........it really works

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-configuration-manager.html

http://www.sqlservercentral.com/Forums/Topic622068-146-1.aspx#bm623115

Nee poda patti 😛

Dude,

Its regarding installing the SP2.Just try installing SP2.