It should work as long as you select the active server name as Colin mentioned.

Thank You,

Best...

Check this one

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

Thank You,

Best Regards,

SQLBuddy

What other processes are running on that day along with your query ?

Run a perfmon counter log along with profiler trace to identify the actual culprit.

...

I agree with these experts.. It's needed.

Test it , gather the results and prove..

Thank You,

Best...

What does your disk couters say

Avg Disk secs \Read

Avg Disk secs \Write

Current disk queue length ...

Also did you run a perfmon trace to find the possible resource bottleneck...

Were the Windows Server & SQL Server built without any issues ?

Did you find any errors in the error logs ?

...

You can use these commands ..

--- Lightspeed Backup TSQL Command

exec master.dbo.xp_backup_database

@database = N'Database_X',

-- @GUID = N'7f771816-757e-40fb-9308-0d1787d50fd9',

@backupname = N'Database_X - Full Database Backup',

@desc = N'Full Backup of Database_X...

What is your actual issue

Are you trying to reduce the Pagesplits ?

Or

Are you trying to find the Cause of Page Splits ?

...

Create a second table on the primary server with identity column so that each record can be uniquely identified and then start the insert in batches 10000 at a time....

Check this one

USE [msdb]

GO

SELECTj.job_id,

j.name,

js.step_id,

js.command,

j.enabled

FROMdbo.sysjobs j

JOINdbo.sysjobsteps js

ONjs.job_id = j.job_id

WHEREjs.command LIKE N'%SSIS%' or js.command LIKE N'%DTS%'

GO

...

Check if this one helps..

SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],

B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],

B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM

MASTER..SYSDATABASES A, sys.dm_exec_requests B

WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE '%BACKUP%'

order by percent_complete desc,B.TOTAL_ELAPSED_TIME/60000...

Detach\Attach method works well. This is much faster than Backup\Restore if you try to do everything in the same maintenance window.

We can also go with restoring Full backups well...

If the server is dedicated for SQL Server and if no other applications are running on it, then making the Page File too big won't help you much.

If you...

Usually we use MPs for the basic tasks like Index Reorg\Rebuilds, Update stats and DBCC checkDB...

And all of theses can be replaced by using custom scripts. Use the excellent scripts...

If you make a DB restore on the secondary server, everything will be over written.

Make the necessary changes on the primary & it will be replicated to the secondary.

...