You're welcome.

Whilst they...

In that case a third node is possible

No, check with your admin, you likely have a dedicated firewall device securing the LAN from the DMZ

you won't

nothing to do with...

the script would do it if it was integrated properly with the T-SQL commands to modify the file locations and offline\online the database. It just requires a little development and...

I'm assuming this is a new share you have created for the backups is it?

\\IPaddress\share

The backup will run under the sql server agent, is this service using a pass through...

Because the log backup went to a location outside of the log shipping backup folder??

Can you...

Firstly, are these questions related to firewall configuration for a SQL server instance?

alanspeckman (8/7/2012)

---

If I am using dynamic port settings on my sql server instance, I need the sql browser...

soccer (8/7/2012)

---

I currently have a two nodes SQL Server cluster. Both nodes have identical hardware (dell R900 servers). I want to add a third node on the existing cluster, is...

Cough cough!!

Angelindiego (8/7/2012)

---

Below is the code I am using to move files from C: drive to F: drive:

ALTER DATABASE MyDB SET OFFLINE;

GO

-- Physically move the file to a new location.

-- In...

@robert sure, no problem

@Hernan shared storage is never good for performance, using multiple logical drives you'll get logical separation but that's as far as it goes

Sqlism (8/7/2012)

---

Hi DBA's

why there are two ports 1433 and 1434 for SQL Server.

whts the purpose of two?

how are they different?

I came to know 1433 is for TCP\IP

1434 for UDP what...

Robert Davis (8/7/2012)

---

Perry Whittle (8/7/2012)

---

Hernán Rojas (8/6/2012)

---

The tempdb can only have 1 filegroup so no you can't put 8 files into 2 different filegroups. The recommendation now is files equal...

get your firerwall admin to check the rules 😉