yeah sure..

Checkpoint will work only when log is >70% full.

So Run Checkpoint manually in the SSMS and see if -ve value exists or not?

When are you facing this problem?

In SQL Server versions before Denali single page allocations and multi-Page allocations are handled by different components, the Single Page Allocator (which is responsible for Buffer Pool allocations and governed...

Good to start by referring below site.

http://www.katieandemil.com/bi-tutorial-from-beginner-to-expert-microsoft-products

In Database mirroring ,mirror server name should be specified in two modes.

1.Implicit mode

No need to specify failover partner here.By the use of SQL provider ,failover will done with mirror server...

I have come across the below nice tutorials.

Refer http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx

Automatic failover failovers all the principal databases to mirror server .

From the replication monitor as you can see the value for Performance critical, Expiring soon/Expired, and Uninitialized subscription are warnings. When a warning is displayed, the Status column also displays...

Hi Friend,

If the number of undistributed commands was very high and increasing. Go and restart the sql server agent at the distributor, and like magic the undistributed commands was back...

See the another thread having resolution..

http://www.sqlservercentral.com/Forums/Topic1030483-146-1.aspx

How can i start the next job step of job in the same job?

I have tried like '--EXEC msdb.DBO.sp_start_job @job_name ='dhhjdhjj', @server_name = N'Sdhjhjfhjfhj',@step_name ='step1'

But getting the...

Please answer the below questions

1.When did log shipping starts failing?

2.Is any associated logs in SQL Server Error log?If yes,send that

3.When did you change 'enabling the compression for full backup'?

I have found the answers in the below url.

http://stackoverflow.com/questions/3776783/how-can-i-query-how-much-time-a-sql-server-database-restore-takes

Hi ,

Try to use the below script

DECLARE @ServiceaccountName varchar(250)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE', N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',@ServiceAccountName OUTPUT, N'no_output'

SELECT @ServiceAccountName

Check the following factors are considered or not?

1.Database size and growth should be mentioned initially.

2.Check the unused index and drop the unused index.

Then set up your maintenance plan for backup,dbcc...