ok, suppose i take full backup which take 5 hour to backup...

at that time user has done some activity in table from applicatiion, and transaction log backup i have take...

I confuse to choose high availability or high performamance...?

My Producation databasae is huge and if it stop for few minuteds, it can create problem with us and alos users.

so i am confused for if i have to keep...

Database mirroring is preferable to log shipping in most cases, although log shipping does have the following advantages:

1. it provides backup files as part of the process

2. multiple secondaries are...

My both server are located in individual location (in in usa and other in Hongkong).so mirroring wirh sync mode will be time consuming to commit in partner server...

yes, i have used for realse..

and also i have require to track alll changes done by user and which one has done it, aslo compare and rollback with previous version...

I have configure SQL Redgate ChangeSet with micosoft VSS..

is it ok?

U can also create procedure :

create PROCEDURE PD_Lista_Tabela_Diferente

(@DBFontes varchar(50),

@DBVerifica varchar(50),

@Iniciais_Nome_Tabela varchar(50)

)

AS

begin

SET nocount off

DECLARE @STR varchar(1000)

CREATE TABLE #TMP_TABELAS_DIFERENTES(TABLE_CATALOG_DBFontes varchar(100),TABLE_NAME_DBFontes varchar(100),COLUMN_NAME_DBFontes varchar(100),DATA_TYPE_DBFontes varchar(100),TABLE_CATALOG_DBVerifica varchar(100),TABLE_NAME_DBVerifica varchar(100),COLUMN_NAME_DBVerifica varchar(100),DATA_TYPE_DBVerifica varchar(100))

SET...

Please create this SP on Master database :

CREATE procedure dbo.proc_compare_databases_tables

@svr_a sysname, -- Servername of source database

@svr_b sysname, --Source database

@db_a sysname, -- Destination servername

...

But i think Mirroring is degrade database performanance than shipping..

I have two machine , one is server and oter is local machine..

I have created one project ifor one database SQL files of all objects of database in SQL Server...

But also i have redgate changeset but how i can configure?

declare @sql nvarchar(max)

DECLARE @dbname VARCHAR(4000)

declare c_db cursor FAST_FORWARD FOR

select name from sys.sysdatabases

OPEN c_db

FETCH NEXT FROM c_db INTO @dbname

WHILE @@FETCH_STATUS = 0

BEGIN

SET @sql...

Pls check the database size and growth given

But Which is best option if i have to implement???

Mirroring or shipping ??