Similar to what I posted yesterday:

-- ENABLE XP_CMDSHELL

SP_CONFIGURE 'XP_CMDSHELL', 1

RECONFIGURE WITH OVERRIDE

GO

SET NOCOUNT ON;

DECLARE

@FILENAME VARCHAR(200)

, @BCPCOMMAND ...

I used google and found this link:

http://www.sqlteam.com/article/exporting-data-programatically-with-bcp-and-xp_cmdshell

And put this together:

-- ENABLE XP_CMDSHELL

SP_CONFIGURE 'XP_CMDSHELL', 1

RECONFIGURE WITH OVERRIDE

GO

SET NOCOUNT ON;

DECLARE @FILENAME VARCHAR(50)

, @BCPCOMMAND VARCHAR(2000)

, @SERVER_NAME SYSNAME =...

Apart from the network issue, which needs to be investigated, how big is the log file and what are the VLF counts on it?

This would also contribute to your recovery...

what are the other queries doing at this point in time? runnable means its ready to go.. but something else might be holding it back, that is not related to...

Hey,

What do the errors in your Application log say?

You mention SQL is struggling to find a path specified?

Where did you want tempdb to be created and are the...

How have you configured your listener?

-- server A

CREATE ENDPOINT VLAN

STATE = STARTED

AS TCP(

LISTENER_PORT = 5022

LISTENER_IP = (10.3.230.10)

)

FOR DATABASE_MIRRORING (

AUTHENTICATION...

Alias will work, in conjunction with DNS entry.

DNS: old servername

Alias: old servername\instance

server: new server

port: whatever port your instance is listening on.

Have you got the transaction sequence number?

You can browse SQL RELP CMDS and see what the row is that is trying to be inserted and either delete it from the...

Yip, you will be asked to reinitialize if you make any changes to the publisher properties.

You can also look at including a script to run after a reinitialize.

or, change the...

Hey,

Try this:

USE [master]

GO

RESTORE DATABASE [Vehicles_new] FROM DISK = N'C:\backup\vehicles_old.bak'

WITH FILE = 1

, MOVE N'Vehicles_old' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Vehicles_new.mdf'

, MOVE N'Vehicles_old_log' TO N'C:\Program Files\Microsoft...

Search for a tool called RSScripter.

This will script your reports out for you and deploy them to the new server

-- use publishing_db

-- GO

select a.name, b.type_desc

from sysarticles a

inner join sys.objects b on a.objid = b.object_id

Also think about how the original cluster design will behave if there is a failure?

How are you going to configure your resources per instance if its on a shared node?

Are...

Do you have a firewall between the servers?

Maybe allow the ports on them.

Nope, if your SQL browser is running and you have enabled TCP/IP for SQL server protocols and set them to listen to all.. you should be fine, without port number.