I do not think you need to do some thing with sp or operating system.

Please tell me little bit more what is the exact problem you are facing.

You are giving expiry date '01/01/2006' Execute as below it will be ok

CREATE CERTIFICATE ElmerEncryptionCertificate

WITH

SUBJECT = 'Elmer Certificate',

...

If you are Admin to the widows server you can change the sa password.

Hi

bkdba suggession will help you.

1. First what is the the volume of data you are inserting, If you are inserting big volume of data it may take 2 seconds or more to insert.

2....

What do you mean by high consumption, are you facing any problem due to tempdb full.

If your tempdb data file or log file is full and it can't grow...

Please let me know your database is OLTP or OLAP.

Thanks for your reply.

Could you please try like this

EXEC msdb.dbo.sp_change_monitor_role @primary_server =

' ',@secondary_server =

' ',@database =

' ',@new_source =

'\\ \LOGSHIPPING\'

Just have a look at

http://www.themssforum.com/SQLServer/spchangemonitorrole-Role/

I am just confused with the error message insufficiant memory and your sollution (you increased the log file space)

could you please explain me more... what happend.

I read, I could not find any enhancements, I Configured the log shipping in SQL Server 2005 for testing purpose.

I did not find the features in 2005.

Any one...

I am also facing the same problem,

My DB size is 38 GB

I am using SQL Server 2000 on Win 2003 SP2

My backup folder was set to compress the files

When I...

I always fight with system and network engineers to add more space, they never understand DBA problems.

I found some more related links

http://support.microsoft.com/kb/319892

http://support.microsoft.com/kb/890637#3a

After log truncation I did T-Log backup I got the below message

There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.

Processed...