Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-18 : 07:56:39
|
| shanly writes "Hi,I have to configure Log Shipping on SqlServer 2000 Standard Edition. I tried by taking a full backup & transactional logs of database from primary server and copy and load to secondary server. After that I run the Transfer Logins Task to configure the logins from the primary to secondary server. But unable to connect to the database using the user login from Query Analyzer.I can login to that particular user login, but not possible to locate the user database.Please help me in this... regardsTony" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-18 : 07:59:13
|
| Did you restore that database yet? If you did, did you restore it in NORECOVERY mode?Are you using the built-in log shipping or third-party scripts? From my understanding Microsoft's log shipping only works with the Enterprise edition. |
 |
|
|
valliyil
Starting Member
8 Posts |
Posted - 2005-03-21 : 02:11:29
|
| I restored the last Transactional Log backup using the RECOVERY mode.I am not using the third party script for log shipping. I found in site that it is possible log shipping using SQLSERVER 2000 Standard Edition using Simple Log Shipper tool. Is it possible to do using that tool?please help me in this. |
|
|
|
valliyil
Starting Member
8 Posts |
Posted - 2005-03-21 : 02:20:41
|
| sorry!! I am the third party script for log shipping. |
|
|
|
valliyil
Starting Member
8 Posts |
Posted - 2005-03-21 : 05:21:56
|
| I using MSSQL 2000 Standard Edition. I perform full database backup on Server A and restore to Server B with same Database name, location, etc.After restore the database, the tables, data is ok but not the user id. I look at the security - logins and can't find the user name but exist in the database I restore.In order for the user id to access back the database, I need to delete the user id in the database I restore and recreate back and set the permissions again.It is any ways to restore the database which includes the user id also?when i tried to create a login in security-login, this error is showing when i tried to create a login in security loginerror 21002: [SQL-DMO] User 'check' already exists |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-21 : 08:10:36
|
| It sounds like you (both) have a login whose default database does not exist on the new server. If it is a SQL login, then the SID values are possibly out of sync between the two servers.You can try running sp_dropuser in the affected database(s) and then try adding the user back to the database. Mismatched users will exist in the database but not be visible through Enterprise Manager, and this procedure is how you fix that.Lastly, do not name user accounts after reserved words. "Check" is a reserved word. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-03-21 : 08:25:49
|
| I am Jack's high availability database.Damian |
|
|
|
|
|
|
|
|
Log shipping