Do you have an index maintenance schedule in place?

As of now, you should rebuild all your indexes.

Not sure what you mean. But a job will get invoked as per its schedule whether it fails or succeeds in a run.

beejug1983 (10/26/2011)

---

Hi,

I have read on internet that if any page is corrupt in database then we have to restore that page from full database backup then we need to restore...

you can query msdb database(restorehistory table) of the secondary instance to check if the restore did not happen for 5 or more hours. If the query returns true, send an...

why go via Oracle way when you can take online backups? Backup processes do not interfare with another user processes.

gissah (10/24/2011)

---

I have a table that contains multiple transactions

column a column b

abnc 123

abnc ...

open profiler, select the events you want to capture, run the trace for couple of seconds then stop.

Then export the trace definition and make changes if you want to (eg...

Query sys.sysfiles.. that will give you information that you need.

Pls note that size in this system view is in number of pages. Divide it by 128 to get space in...

append a timestamp to the filename. example below adds only date. you can also add time to the filename. everytime the script runs, it'll generate new backup files.

strFile = 'backup...

select count(*)*8/1024 AS 'Cached Size (MB)'

,case database_id

when 32767 then 'ResourceDB'

else db_name(database_id)

end as 'Database'

from sys.dm_os_buffer_descriptors

group by db_name(database_id), database_id

order by 'Cached Size (MB)' desc

Gives you space used by each database in the...

Where are you checking the status of the database. As per BOL, a database can have one of the following states.

online, offline, restoring, recovering, recovery pending, suspect and emergency.

what is...

what do you mean by retiring?

What does this return?

sp_configure 'show advance options',1

go

reconfigure

go

sp_configure 'recovery interval'

go

Edit - correction made

3 things.

1. provider should be SQLOLEDB

2. Conn is your connection object, why are you writing conn1.open?

3. remove all single quotes from the connection string.

When SQL Server encounters a deadlock, it automatically resolves it by killing one of the deadlock participants (victim). Enable trace flag 1222 which will log deadlock information in the error...