Look for sp_help_revlogin on support.microsoft.com there are all the scripts and full instructions for usage there.

Run sp_helprev_login on the main server.

Apply the script on the standby server.

Because the SIDS will match up you won't need to run any update to the users in the databases.

This has driven me insane. This is not available and I have no idea why this would not be functionality, it's not there in 2008 either (however on the feature...

Boil it down real quick.

It does delete, however hangs on to it for a bit in the filesystem before it does it, just in case.

I wouldn't worry about the differential backup so much as actually being able to restore from an Arcserve backup. Just curious as to whether you've tried it and actually been...

If you don't have to take the old server down just run them from there, and migrate as you are able to turn them into SSIS packages.

I'm going back to 2000 from 2008 and haven't encountered any issues. Just ensure that when you create publications don't enable the option to replicate compression settings as they are...

I am seeing the same behaviour with my 64bit version of 2005 as regards the AWE piece, so I don't think that's a problem.

You can configure the MAXDOP value on...

You can certainly just install the client components, just as you could in 2000. Just select the client in the installer dialogue, remove everything else, and you are golden.

Nice, didn't even know that you could do that. Will remember that one for the future.

Thanks

You'll need to perform a substring function against the data to get rid of the $ when attempting to execute the query.

Another way would be to use a computed column...

Try pulling the backup locally and not restoring over the network should provide an enhancement.

This might seem a little strange, but try lowering the MAXDOP value to half the number of cores on the system (I'm not sure how many cores you have on...

ashok (2/9/2009)

---

hi friend,

Thanks I think i am near from output. I asked my question this one. what is this error.

What software i need to install to send mail.? kindly give...

Only use the backup exec stuff if you don't want to do a restore.

I've yet to see a backup vendor produce a product to backup databases directly to tape that...