Viewing 15 posts - 211 through 225 (of 243 total)
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...
November 22, 2008 at 2:37 am
I confuse to choose high availability or high performamance...?
November 21, 2008 at 11:50 pm
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...
November 21, 2008 at 11:03 pm
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...
November 21, 2008 at 7:29 am
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...
November 21, 2008 at 2:13 am
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...
November 21, 2008 at 2:09 am
I have configure SQL Redgate ChangeSet with micosoft VSS..
is it ok?
November 20, 2008 at 10:11 pm
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 @STR =...
November 20, 2008 at 9:48 pm
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
...
November 20, 2008 at 9:46 pm
But i think Mirroring is degrade database performanance than shipping..
November 20, 2008 at 9:40 pm
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...
November 20, 2008 at 3:43 am
But also i have redgate changeset but how i can configure?
November 19, 2008 at 9:52 pm
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 =
'use '+ @dbname +';
SET...
November 18, 2008 at 11:26 pm
Pls check the database size and growth given
November 18, 2008 at 10:07 pm
But Which is best option if i have to implement???
Mirroring or shipping ??
November 18, 2008 at 10:04 pm
Viewing 15 posts - 211 through 225 (of 243 total)