how about Log-shipping?

hi marketwiz88 

Please contact me offline at bmlakhani@yahoo.com

or blakhani@messengeruser.com

my 2 C, Other than backup, I can think of having a scheduled package which transfers the data after cleaning previous data. I am not sure how many tables and...

what is the query?

select * from <table> or something more complex.

It is consistent? Even if you open new connection it gives same error?

what is the output of

dbcc inputbuffer(<SPID&gt

Restarting should solve this

I am assuming that it is not WMSDE (another version of MSDE which does not allow network connection)

If its MSDE, you CAN connect from remote clients. Please check if you...

This message is very generic and can happen because of many reason. I would start troubleshooting this by:

1. Service is up and running?

2. What name you are giving while connecting...

Siva,

Please contact me offline at bmlakhani@yahoo.com

Did this happen after applying SP4? I am assuming that this never worked. If yes, then there is something wrong with Active Directory.

please check the following.

1. Version of 'xpstar.dll'

2....

Don't take log backups of the database which is getting shipped because this will break the LSN chain of the logs getting applied on secondary.

as indicated by "colin Leversuch-Roberts" Full...

chandrika5 is talking about SQL Error Logs or Transaction Logs of the database?

SQLBill gave info about T-Log which is perfect

sp_readerrorlog is the stroedprocedure...

Please note that the sequence of the full and the differential had to be followed.

So basically there should be a full database backup taken LATER than the one we were...

You need to take regular log backups. Best way will be to take log backup and shrink the file after that.

What is the exact command you were running to install service pack?

As far as i understand, it is failing during "configuing server".

If you have verbose log output with you,...

A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server

http://support.microsoft.com/default.aspx?scid=kb;en-us;317375