Not really, I just encounter this problem today 😉 man you are so harsh

Reasons why database recovery will take longer than normal:

1. when you restart you database and you are processing transactions. You should stop all transaction 1ft before restaring you sql

2. you...

Thank you!

can you give me an idea or T-sql code on how to convert import sql server agent job. thanks!

Because I am using Border Gateway Protocol which will route my IP address if the network server is down.

BGP has capability to go back to original IP address once it...

thanks! to work around with this I add a job that will check the linked server of the original principal server. If it linked then change to the original role.

Is...

Thank you this works for me 😀

Create Table #Output

(

Output varchar(150) default('')

)

INSERT INTO #Output

EXECUTE xp_cmdshell 'ping 192.168.10.1'

SELECT *

FROM #Output

I have questions:

Headcount of what?

is user_id column is unique?

Thank you!

I found out I have to stop the mirroring 1st.

Use master

-- Stop mirroring

ALTER DATABASE [Database]

SET PARTNER off

-- Set to recovery

Restore Database DBMirror

with recovery

What I suggest involved several processes but it is more effecient way to do it.

Why dont you create txt/csv files and put it in FTP folders (main server ...

Hello,

Make sure you have the rights to access the remote server or the server you are trying to linked. You also should consider creating login for the linked server.

Query...

Is there a way to set up the DNS for the port of the SQL? I am using 5022 port right now.

Thank you so much for your help. I really...

yes we do have fire wall. hmmm actually it is server between 2 fire wall but it is strange because I cannot even ping the server I am working on...

I can ping Servername.Domain but if I add the port Servername.Domain:Port it could not find my server. any idea why please. I use port 5022.

Thanks!

hmmm I have this for both servers (principal and mirror)

SELECT name, role_desc, state_desc FROM sys.database_mirroring_endpoints

Result: MirroringPARTNERSTARTED

SELECT name, port FROM sys.tcp_endpoints

Result:

Dedicated Admin Connection0

TSQL Default TCP0

Mirroring5022

I can ping each other...

Hi,

Please help. I just installed SP2 both on my servers (Principle and mirror server).

When I am trying to start the mirroring I recieved this error:

Server Network address TCP://ServerName.domain segment:Port can...