Sorry for not making it clear. The tasks do have different results on the source server. But I assume it would not have any difference on the target or destination...

Thank you, Steve.

I checked the logs and didn't find any error. I ended up re-establishing logshipping. What if this happens on a production server?

I have seen this a few times. What I ended up doing was using the UNC path pointing to the share and it worked. Make sure you create a share...

Thank you, guys. I changed the two Nulls to 'sa' and it solved the problem.

Thanks again!

quote:

---

I believe this error occurs when one or more databases are owned by server's login which doesn't exist anymore. Try to run...

Thank you, JM. We are just trying to isolate the production environment. I am just concerned that installing another cluster virtual server on the existing production cluster would interfere the...

Thank you!!!

Thank you, Jonathan. You are right. The compatibility level is 65. What determines the compatibility level? What can be done to make it 80? Thanks again.

Thank you, guys, for all your help.

Andy is right. There are two databases on the server with similar names. I was attaching the wrong files...

I thought detach and attach would...

Has anybody done this? Any input would be appreciated. Thank You!

quote:

---

Using AWE Memory

To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has...

Thank you, Allen. What I worry is that: does it truncate any data? How could the data file shrunk 90%? Does it do the same thing as Shrink Database in...

Yes. I put the data file as the input file...

Thank you, David, for the helpful instructions. It worked!!!

HELP! HELP!