The logical file name should not change unless explicitly changed by someone. Is it just yourself who run this server?

BACKUP DATABASE 'database-name'

TO DISK='your file path'

trry this and let us know

Have you found a way yet?

You can use this query:

SELECT DB_NAME(database_id), LastRead = MAX(CASE

WHEN last_user_seek > last_user_scan AND last_user_seek > last_user_lookup

THEN last_user_seek

WHEN last_user_scan > last_user_seek AND last_user_scan > last_user_lookup

THEN last_user_scan

ELSE...

Correct

2) If the answer to the first question, is yes, this means that the stating tables that...

Backup and Restore method

Attach/Detach

SSIS

Scripting

Easiest method is Backup and Restore to 2008, change the compatibility level and fix the logins.

Only Re indexing does not help. What are your table schemas and what are your frequently running queries?Would you...

Yes, you should monitor the server when it is busy and identify the queries that are causing performance problems at least couple of them and try to tune it and...

Wooo...tht's the way to go fire back to the developers :-D, where it came from

Yes, try to trace the queries that are running against the table. Identify them and troubleshoot them.

Check to see TOP 10 waits

SELECT TOP 10

wait_type,

...

Yes, true as what Lowell advised and also you can restore v8 to v9 too. you should not face any problem in that.

There is a foreign key referenced to this table, so...

Hi,

Yes, that's right it's corruption in the clustered index which is the data itself, you would be able to repair it but with some amount of data loss.

Why is your...

What are you trying to do here? I mean are you dropping any of the tables?

Am sure Paul will be around in sometime until then

Check out Paul's blog:

http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Using-DBCC-PAGE-to-find-what-repair-will-delete.aspx

Its a corruption on the leaf level pages of the index, if you run REPAIR_ALLOW_DATA_LOSS obviously it would delete the data that it could to repair the database. Basically, REPAIR_ALLOW_DATA_LOSS...