Viewing 15 posts - 151 through 165 (of 243 total)
Yes u get error, but backup id done..
u can see the backup and database is also created..
December 23, 2008 at 2:35 am
If i choose Clustering, which should preferable Active /Active or Active/Passive?
December 23, 2008 at 2:31 am
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...
December 22, 2008 at 10:42 pm
Can you please explain me the difference between Active/Active clustering and Active/Passive clustering.
I am very confuse.
December 22, 2008 at 10:35 pm
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...
December 22, 2008 at 10:29 pm
You can setup Replication ,Mirroring or Log Shipping in this case.
December 22, 2008 at 10:16 pm
You can set no of maximum user from configuration.
December 22, 2008 at 10:13 pm
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...
December 22, 2008 at 7:08 am
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...
December 22, 2008 at 2:16 am
select table_name, column_name
from information_schema.columns
order by table_name
December 22, 2008 at 1:56 am
Sorry @filecontent is not displayed, bec it contains open tag ' '
so, can u tell me, how can i write ' ' in file ?
December 18, 2008 at 11:58 pm
U can make DDL trigger to trackout DML changes from user.
and make DDL trigger to trackout DDL Trigger for structure change.
December 18, 2008 at 1:31 am
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 ,...
December 18, 2008 at 1:26 am
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...
December 18, 2008 at 1:20 am
Viewing 15 posts - 151 through 165 (of 243 total)