check this link

http://www.sqlservercentral.com/Forums/Topic463926-266-1.aspx

What is the size of the backup file? Is SQL Server with SP2?

May be permission issue. Check if SQL Server startup account have all the permission to write on to the backup folder. OPerating system error 2 :- The system cannot find...

You can use RESTORE FILELISTONLY which will return list of the database and log files contained in the backup. If your backup have 2 data file and 2 log file...

The changes will be reflected...

Bingo !!:-D

I resetup the Transaction Replication with readonly subscribtion and the local users are able to update & insert the data to the subscribtion Database but the changes are not...

Thanks for reply.

I think updatable subscribtion will propagate updates to the publisher which I dont want. My req. is publisher should updates the subscribtion so that the data are in...

THe following steps helped me to solved the issue.:-)

SELECT [name], [log_reuse_wait], [log_reuse_wait_desc]

FROM sys.databases

My result was:

name log_reuse_wait log_reuse_wait_desc

dbname ...

I had reintilized the replication and but not able to truncate it as it gives file in use error message.

The error message which I had mentioned in the post...

REPLICATION for the specified DB. I know snapshot replication have been setup.

also dbss sqlperf(logspace) gives me 100 % space used for the same DB.

I dont have disk space. But need...

Check if the SP3 has been applied successfully or not? You also need to apply the recent patch(CU1).

Check this link this might help you.

http://sqlserver007.wordpress.com/2009/02/19/problem-with-maintenance-plan-in-sql-server-2005-after-installing-sp3/

SQL Server: Memory Manager: Connection Memory (KB) will give an hint of how much memory is getting used by SQL Server will give the information also try using DBCC memorystatus.

http://support.microsoft.com/Default.aspx?id=271624

First post it in the right forum. You need to run DBCC CHECKDB command to find out if there is any corruption I mean incosistency in your DB. some time...

We have decided to take the SQL Server backup to Tapes using Tivoli instead taking the backup location ( Disk) to Tape which was suggested earlier.

Need help in setting...

Thanks for the reply .. Will coinsider this option.