Satish Nagaraja (6/4/2012)

---

Would advice to check the hardware related counter to determine bottleneck as listed below if you have not checked.

How good is DISK IO ? Check the counters DISK...

Still my issue is not yet solved.

Is any one please suggest, what i have to do the SWITCH between one table to another table

Hi,

I added the check constriants as a soluation in other articles...But not solve the issues.

Following conditions i added to the tables

ALTER TABLE dp_test1 WITH CHECK ADD CONSTRAINT [Chk] CHECK...

It create a dead lock between re-index table and update or select table.

but you can reduce the load to change the DB to simple recorvery mode first and after re-index...

Dear Gail

How i can check DB, even if i restore or attach file.

Regards

Mathew

Hi,

Storage is formated and it have the .mdf file and .bkp file.

We recovered the files with some undeleted command. But these files are not working for restore the DB or...

HI,

I also tried the bulk-logged recovery. But it increases the log file size and reduce the performance of re-indexing.

Really there is a risk. If server down after re-index and before...

Thanks for your reply.

In sql 2008, where i can see the lock/process information.

Only way is to use sp_lock or any better way to view it

Regards

Mathew

Hi,

I need every year Jan to Nov 2

Like 2007 = Jan to Nov2

2008 = Jan to Nov2

2009= Jan to Nov2

2010 = Jan to Nov2

Now it returned all the record from...

hi,

Running total from Jan 1 to Today date( jan 1 to Nov 2).

Mathew

Hi Ali,

Errors was in SQL 2008 and i Install Service Pack 1 in Sql 2008.

My Sql 2000 have Service pack 4 and i took backup from Sql 2008 service...

Thanks ..Now the 2000 Db restored in Sql 2008.

The issue was service pack. After i apply the service pack 1, it restore the db in sql 2008.

it shows the following...

Hi

I check teh "RESTORE VERIFYONLY FROM DISK='[Mention the path of backupfile]'" and it is successful. It shows message that back is redy for restore.

I check the Check db command and...

No..I am not appled the latest service pack.

Dear Nakul,

The file are restored in the folder and it is same size of the DB file and logfile.

The folders are not compressed one.

Mathew