Yes u get error, but backup id done..

u can see the backup and database is also created..

If i choose Clustering, which should preferable Active /Active or Active/Passive?

Restore is process ro any database backup to existing database or create a new database.

and

Recovery is the process to take database online and suppose u restore first full backup...

Can you please explain me the difference between Active/Active clustering and Active/Passive clustering.

I am very confuse.

SELECT object_name(object_id), d.*, s.*

FROM sys.dm_db_missing_index_details d

INNER JOIN sys.dm_db_missing_index_groups g

ON d.index_handle = g.index_handle

INNER JOIN sys.dm_db_missing_index_group_stats s

ON g.index_group_handle = s.group_handle

WHERE database_id = db_id()

ORDER BY object_id

This script help u...

You can setup Replication ,Mirroring or Log Shipping in this case.

You can set no of maximum user from configuration.

SP_CONFIGURE 'Database Mail XPs',1

GO

RECONFIGURE

GO

THIS WORK BEST :

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE trigger [BACKUP_NEWDB]

on ALL server

for CREATE_DATABASE

as

begin

COMMIT TRANSACTION

DECLARE @NEWDB VARCHAR(500)

DECLARE @BACKUPSQL...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE trigger [BACKUP_NEWDB]

on ALL server

for CREATE_DATABASE

as

begin

DECLARE @NEWDB VARCHAR(500)

DECLARE @BACKUPSQL NVARCHAR(500)

SET @NEWDB = (SELECT TOP 1 NAME FROM...

select table_name, column_name

from information_schema.columns

order by table_name

Sorry @filecontent is not displayed, bec it contains open tag ' '

so, can u tell me, how can i write ' ' in file ?

U can make DDL trigger to trackout DML changes from user.

and make DDL trigger to trackout DDL Trigger for structure change.

U can not reconnect it, but u can find it and stop it

select * from fn_trace_getinfo(0)

u can find traceid and to stop run below:

sp_trace_setstatus [ @traceid = ] trace_id ,...

For that u have to run query

select * from sys.sysprocesses

when u run the qury, u will be find waitresources, it will be like 12:12344:778

From that u have to analize...