I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent in the one that was restored. I expected it to be backuped to the bak file !
Is there any special manipulation for a login to be backuped in order to be easily restored on another server ?
I could not go on maintaining various script to restore the database on one hand and to recreate the logins on the other hand.
How could I create a consistent backup file that could easily be restored ?