Not sure about local subscriber, try it, we have a mirror server in another US state, and after fail over to mirror replication worked fine.

In Replication Monitor find out Agent Profile for snapshot and Log reader Agent and in

-PublisherFailoverPartner type in mirror server name

From Tim Ford's article "Rebuilding the SQL Server master database"

--CODE BEGIN

DECLARE @Command_Detach VARCHAR(1000)

SELECT @Command_Detach = '

IF N''[?]'' NOT IN(''model'' ,''master'', ''msdb'', ''tempdb'')

BEGIN

SELECT ''EXEC usp_KillDBConnections ''''?''''...

When I faced same issue with 250M rows table I did:

1.Create tmp_table with the same structure

2.Drop all indexes from production table except PK

3.Import data by 50M rows using Import/Export utility

4.Create...

What I did when faced this issue with 250M rows table was:

1.Create a new tmp_table

2.drop all indexes from production table except PK

3.Insert data in the new table by 50M rows...

Check RedGate and Idera. They have lot of what you are asking.

First - In SQL Server Configuration Manager create an alias for your named instance with port number.

And second - to run it from sql server

Declare @sql varchar(500)

set @sql = 'exec master..xp_cmdshell...

SQL2005 doesn't allow trusted connection in bcp. Use -U<power user name> -P<password>  and it will work.

Add a fully qualified path to DTSRUN.exe

"C:\PROGRAM FILES\MICROSOFT SQL SERVER\80\TOOLS\BINN\DTSRun.exe"  /S "(local)" /E /N "PB_Active_InspectorReportExport"

The easiest way to remove user's connections is in EM right click on DB name >> all tasks >> detach database and press clear button to kill all connections. After...

Snapshot replication doesn't need PK.

select t.entry_time,convert(nvarchar(3000), c.command) from msRepl_commands c, msRepl_transactions t

 where c.xact_seqno = t.xact_seqno

Port 1434 came from ishaan99's email

Go to Client Network Utility and create an Alias using proper port number or use IP, 1434

1.select isnull(datalength(col1),0)+ isnull(datalength(col2),0)+ isnull(datalength(col3),0) from <table_name>

2. Go to EM right pane > right click on table name >design table > right click on col2 > insert col4  and save it.