Actually using disk deframentor in Windows part of the maintance. I agree that you need to scheduled on windows level for once in a month.

As you are using disk deframentor...

Hi Anu,

Please follow the instructions below.

1) open the SQL server,

2) Connect to the particular DB

3) Opne the Query Analyzer inSQL 2000 and in 2005 Click on New query tab,

4) Write...

Ok, Make it Simple.

Restore recent full backup and try to restore the all diff backups. After restoring all diff. backup try to restore all Trn backups until las trn backup.

If...

Ok, Make it Simple.

Restore recent full backup and try to restore the all diff backups. After restoring all diff. backup try to restore all Trn backups until las trn backup.

If...

Ok, Make it Simple.

Restore recent full backup and try to restore the all diff backups. After restoring all diff. backup try to restore all Trn backups until las trn backup.

If...

Hi,

I beleive SQL 2005 version 9.00.3042 will resolve the issue. I had the same issue when I used and that time I had 9.00.2047 version of SQL 2005. I upgraded...

It is not necessary that you same svc a/c and password for the both servers, but be note this point.....

1) Svc a/c should be part of SA permission no login...

Hi,

Please check this.....

sys.dm_exec_cached_plans,

sys.dm_exec_sql_text, (dm_exec_sql_text(sql_handle))

sys.dm_tran_locks ,

sys.dm_exec_sessions

--Top 5 CPU average CPU time

SELECT TOP 5

total_worker_time/execution_count AS [Avg CPU Time],

(SELECT SUBSTRING(text,statement_start_offset/2,(CASE WHEN statement_end_offset = -1 then LEN(CONVERT(nvarchar(max), text)) *...

I would recommand you to stick with the dbo mode for all tables, It is the best practice from the microsoft.

Create new roles for those 4 users,

Give them access on...