Yep!! It seems to me also that registry is not clean and so u r facing the issue. Why don't u try a registry restore with a good available back up?...

Lee,

I never faced this issue... [Rtaher not though on it ]. But what do u think on the below stretagy?

1. Leave the time...

Alternately, go to EM and do the following:

1. Select the DB

2. Right click --> Go to DBProperties

3. Select the Data/File u want to rename/alter

4. Click on the Grid containg it's...

I strongly suggest.. u take a dry test to recover your DB per the DRR plan

Nope. Next time u will use SQL installation.. it will report a name mismatch and ask u to rectify it.

Please grant permission to the account on the selected database specifically and ensure that there is no deny on that user to that db/table. Deny overrides grant.

As you told, you...

Assuming your job configurations as below now:

U r job is at 2K box and 2K5 is a linked server

Ur job works on a 2K5 table of that...

Have u used virtual back up device and trying to restore db from that? If so.. check the status of the device if it is ok or broken...

Hi

Are you using WIndows Authentication Mode on both the boxes? Please cross check if the account which is running the job in your 2K box is having the required permission...

Suresh,

Can try to use this also:

IF EXISTS(SELECT name

              FROM            sysobjects

              WHERE  name = N'TABLE_NAME'

              AND  type = 'U')

DROP...

It depend on your requirement and the cost you can afford.

Step1: It s better to decide a recovery plan for all the databases and then generate a backplan for each...

Thanks.. I asked one of our developer to come up with the script which will compare both the tables and alter the SQL table before the data pump.

But.. I am...

I think.. it is better not to adopt shrinking as a regular practice. But if the database is reserving huge volume of unused space with in it.. it is better...

Yes!! I also copy huge tables from one server to another / access to sql server. I keep destination database in simple recovery mode so that log space does not...

PLEASE IGNORE/DELETE THIS THREAD AS THIS IS A DUPLICATE