Search Results | SQL Server Performance Forums

SQL server 2005 to oracle + connect over internet (https?)

Post by: davida37, Nov 5, 2008 in forum: SQL Server 2005 General DBA Questions

Hi, none of these articles refer to securing the connection. I need to know if its possible to secure the data between an oracle db and a sql server...

SQL server 2005 to oracle + connect over internet (https?)

Thread by: davida37, Nov 5, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

hi, It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a...

Difference between Log shipping in Full or Bulk Logged Recovery mode

Post by: davida37, Sep 3, 2008 in forum: SQL Server 2005 Log Shipping

thanks Mohammed

Difference between Log shipping in Full or Bulk Logged Recovery mode

Thread by: davida37, Sep 3, 2008, 2 replies, in forum: SQL Server 2005 Log Shipping

Hi, What is the difference between log shipping in Full Recovery mode and Bulk Logged Recovery mode? The aim for me, is to keep the size of...

Autogrowth setting + Minimising fragmentation

Thread by: davida37, Sep 2, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

I have a datamart (dm) database which we replicate into each night. This dm is currently 30GB in size. I am trying to keep fragmentation to a...

Transaction log shipping + Size of Transaction log file growth after maintenance plan

Post by: davida37, Aug 27, 2008 in forum: SQL Server 2005 Replication

thanks for the prompt reply. disk space isnt the issue and there is ample disk space to play with (100gb + ) but we need to keep the size of the t...

Transaction log shipping + Size of Transaction log file growth after maintenance plan

Thread by: davida37, Aug 26, 2008, 3 replies, in forum: SQL Server 2005 Replication

Hi, Please help ...We're using SQL Server 2005 Standard Edition. We have a production db and ship and restore logs onto a standby server. I generate...