you can register your sql 2000 instance with ssms 2008 and...

As its for one database then yes you can configure logshipping. And as per your requirement, the steps should be:-

1) Take full backup on primary and restore on secondary with...

I agree with Wayne, if you look into requirement of your boss then seems like he/she is trying to reinvent the wheel of automating the failover.

Tell him clearly the process...

to restore 2000 image to 2008, i think would be quiet complicated.

My personal suggestion is if this is just refreshing server B database with Server A every day, and if...

both have the different compression algorithm. And I personally prefer litespeed.

if you run the hostname on dos prompt, are you getting xyz or ABC?

Also I beleive you saying that when you running select @@servername, you getting the incorrect server name.

If...

mirroring vs logshipping

1) automatic vs manual failover

2) high performance vs compromise on performance

3) highly synchronize vs compromise on synchronisation

4) 3 option available in mirroring for performance vs availability, nothing such...

If your motive is to keep second node uptodate with primary then

I will suggest instead of daily doing restoration, you should consider logshipping,mirroring or replication.

Also the more clear your...

1) if you want to wait for completion then wait for message...query executed successfully.

2) if want to kill and re-run with 'stats' option then stats = 10 will keep informing...

before running the restore command, you could have used 'stats' option which gives the information how much % iscompleted.

The only option left is :-

1) Will till complete restoration msg

2)...

Also I beleive you have table 'ERRORLOG' in database because I tried it and able to generate the text in @SQLQuery

Are you able to send test mail using :-

@profile_name = 'default' and

@recipients = 'xxxxx@xxxxxxx',

And I am sure you have enabled mail in advance configration.

If the above testing works then...

thats really interesting to investigate.

Can you find out the top 5 largest table in your database and how frequently they are getting updated?

Also,

If you take full backup now...

ok, so if I am getting you correctly then you want only first three value. In that case take the full name in a variable(say x) and count the space...

its too tough(for me) to find where exactly you taking the nmae value in a variable but I suspect this could be because of length of variable. If you...