Yep thats what I'm trying to do. The post was mis-leading.

Corrupt backups are not included in the Attempt to restore.

BACKUP A

TRANS A-Z

Z restore with recovery.

Backup B & C just to...

Can I only restore up to TRANS BACKUP D.

This will mean data loss.

What are the data types of the tsble, are there any large data types ie VARCHAR(MAX),TEXT etc.

What is the data size of the whole table.

Is it waiting to get exclusive...

One thing I never encountered is corruption of a db. It makes me nervous for some reason just thinking about.

Currently I backup and restore a few main production dbs to...

One thing I never encountered is corruption of a db. It makes me nervous for some reason just thinking about.

Currently I backup and restore a few main production dbs to...

Can you see if something is leaving allocated pages in tempdb.

select * from sys.dm_db_task_space_usage

where internal_objects_alloc_page_count <> 0

Anything which has an high alloc and low dealloc. Then whatever that spid is...

Easily done Via SSRS configuration tools.

If you want to keep the original SSRS dbs for rollback.

1 Backup the dbs with copy.

1a Backup SSRS encryption keys\cert.

2. Restore the dbs as...

It looks that way. It's a no go for me due to the connection issues and the fact I'm running on Windows 2008 R2 x64 bit which it is advised...

Thanks Steve.

Tested, JUST FOR INFO.

SQL 2000 installed fine, but with remote connection issues.

Checked the usual

Browser Service running

Permissions

TCP\IP enable

Port enabled in Firewall

SP4 installed server rebooted.

Still no remote connection.

This is all...

Sorry Steve I think you misunderstood the question.

I have used SQL 2000 many a time as a named instance.

As I haven't worked with SQL 2000 for about 3 years now.

My...

Use the Repoting services configuration manager on the system you want to move.

Backup the RS encryption cert . Backup the RS and RSTEMPdb with copy.

Install SSRS on new machice....

Is there a Domain Policy in effect that stops an account from running as a service.

Is the folder (WINDOWS FOLDER for SQL agent) accessible by the account running the service?

Can...

Run this...

select * from sys.dm_db_task_space_usage

where internal_objects_alloc_page_count <> 0

See which spid has an high 'internal_objects_alloc_page_count'

and a low 'internal_objects_dealloc_page_count'

then see what these spids are doing.

Do you use Service Broker at...

There is a lot more work needed if this is to be done properly.

Shrinking the data file is simply a bad idea and a simple index rebuild is not sufficient.

http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/

from...

Can't believe no one has pointed out that is not a good idea to shrink Production DBs.