1) Maximum downtime : 1 day

2) Edition: SQL 2008 R2 , Enterpirse

3) How long does it take to restore:10-12 hours

4) Primary filegroup contains mainly application meta data and it is...

can somebody from canada help. Even I am planning to migrate. But dont know where to start. Please help.

Is this correct? I thought on active node and...

As far as I know, you cant get it unless you use dos commands using xp_cmdshell.

Backup path can be found from msdb.dbo.backupmediafamily.

For Schedule related info refer to

http://solihinho.wordpress.com/2009/01/01/query-for-listing-sql-server-job-schedule/

Requires you to create 3 functions on master database

your data and problem is not clear. Can you post your sample data and expected result in excel sheet and post it as attachment.

You can do the same. Click on 'Jobs' underneath SQL Server Agent on the management studio.

On the right side you should see a tab called 'Object Explorer details'. Select all->Right...

I am not sure how multiple LDFs can help either. SQL Server treats multiple log files as single log file only and uses them on a sequential basis, allocating VLFs...

How about using two different SQL accounts. the one used for checking using should be a low previlage one something like Readonly rights. The one used while synchronising should be...

@Larry,

If its SQL 2k5 or 2k8, then DMVs like dm_os_ring_buffers,dm_os_waitstats,dm_os_schedulers can help.

If interested, refer to the following two whitepapers.

Waits and queues - Check cpu pressure section http://msdn.microsoft.com/en-us/library/cc966413.aspx

Troubleshooting performance...

Pradip,

The link posted is not working. Post again.

as a first step, you can try creating i, linked server using sql authentication to ensure its not a firewall issue.

But looking at the error msg you have posted it...

What about @@CPU_BUSY and @@IO_BUSY

if you checked those two values e.g. every 10 seconds and the @CPU_BUSY had increased 8 seconds I would assume that it was running on 80%,...

Good article. Handy way to monitor CPU.

But one improvement I would like to see is a way to find which process is causing the CPU hit.

It may not be...

Hi Simon,

Thanks for such a nice explaination. I have some diffrent case hope you will give suggestion for this.

I did logShipping for a large database now the file size increased...