Creating a Standby Server

Hi,
SQL2000 Std edition.
I'm creating a standby server to use for disaster recovery, etc.
There are 2 servers involved, the primary and the standby, that's all.
I don't know which SQL system databases I need to restore from the primary
to the standby.
I've restored all the application databases with no problem, but can't use
the application on the standby because of "user unknown" problems. Obviously
I've not got essential user role and permission data.
However I'm not sure if I can just restore all the following with no
problems. (I understand I can't restore any transaction logs for the master
database.)
master
model
msdb
pubs
tempdb
My concern is that if I restore them all the standby server will then
contain irrelevant data or it will think its a different server!
Thanks
Steve W
I suggest you read the information about log shipping in below documents:
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
And also search KB for sp_help_revlogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SteveW" <SteveW@.=No=Spam.org> wrote in message news:%23bMmp%23qhEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> SQL2000 Std edition.
> I'm creating a standby server to use for disaster recovery, etc.
> There are 2 servers involved, the primary and the standby, that's all.
> I don't know which SQL system databases I need to restore from the primary
> to the standby.
> I've restored all the application databases with no problem, but can't use
> the application on the standby because of "user unknown" problems. Obviously
> I've not got essential user role and permission data.
> However I'm not sure if I can just restore all the following with no
> problems. (I understand I can't restore any transaction logs for the master
> database.)
> master
> model
> msdb
> pubs
> tempdb
> My concern is that if I restore them all the standby server will then
> contain irrelevant data or it will think its a different server!
> Thanks
> Steve W
>
|||Hello
Please refer to the following article for more information :
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Creating a Standby Server

Hi,
SQL2000 Std edition.
I'm creating a standby server to use for disaster recovery, etc.
There are 2 servers involved, the primary and the standby, that's all.
I don't know which SQL system databases I need to restore from the primary
to the standby.
I've restored all the application databases with no problem, but can't use
the application on the standby because of "user unknown" problems. Obviously
I've not got essential user role and permission data.
However I'm not sure if I can just restore all the following with no
problems. (I understand I can't restore any transaction logs for the master
database.)
master
model
msdb
pubs
tempdb
My concern is that if I restore them all the standby server will then
contain irrelevant data or it will think its a different server!
Thanks
Steve WI suggest you read the information about log shipping in below documents:
http://www.microsoft.com/technet/pr...oy/sqlhalp.mspx
And also search KB for sp_help_revlogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SteveW" <SteveW@.=No=Spam.org> wrote in message news:%23bMmp%23qhEHA.556@.tk2msftngp13.phx.gb
l...
> Hi,
> SQL2000 Std edition.
> I'm creating a standby server to use for disaster recovery, etc.
> There are 2 servers involved, the primary and the standby, that's all.
> I don't know which SQL system databases I need to restore from the primary
> to the standby.
> I've restored all the application databases with no problem, but can't use
> the application on the standby because of "user unknown" problems. Obvious
ly
> I've not got essential user role and permission data.
> However I'm not sure if I can just restore all the following with no
> problems. (I understand I can't restore any transaction logs for the maste
r
> database.)
> master
> model
> msdb
> pubs
> tempdb
> My concern is that if I restore them all the standby server will then
> contain irrelevant data or it will think its a different server!
> Thanks
> Steve W
>|||Hello
Please refer to the following article for more information :
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Creating a Standby Server

Hi,
SQL2000 Std edition.
I'm creating a standby server to use for disaster recovery, etc.
There are 2 servers involved, the primary and the standby, that's all.
I don't know which SQL system databases I need to restore from the primary
to the standby.
I've restored all the application databases with no problem, but can't use
the application on the standby because of "user unknown" problems. Obviously
I've not got essential user role and permission data.
However I'm not sure if I can just restore all the following with no
problems. (I understand I can't restore any transaction logs for the master
database.)
master
model
msdb
pubs
tempdb
My concern is that if I restore them all the standby server will then
contain irrelevant data or it will think its a different server!
Thanks
Steve WI suggest you read the information about log shipping in below documents:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlhalp.mspx
And also search KB for sp_help_revlogins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SteveW" <SteveW@.=No=Spam.org> wrote in message news:%23bMmp%23qhEHA.556@.tk2msftngp13.phx.gbl...
> Hi,
> SQL2000 Std edition.
> I'm creating a standby server to use for disaster recovery, etc.
> There are 2 servers involved, the primary and the standby, that's all.
> I don't know which SQL system databases I need to restore from the primary
> to the standby.
> I've restored all the application databases with no problem, but can't use
> the application on the standby because of "user unknown" problems. Obviously
> I've not got essential user role and permission data.
> However I'm not sure if I can just restore all the following with no
> problems. (I understand I can't restore any transaction logs for the master
> database.)
> master
> model
> msdb
> pubs
> tempdb
> My concern is that if I restore them all the standby server will then
> contain irrelevant data or it will think its a different server!
> Thanks
> Steve W
>|||Hello
Please refer to the following article for more information :
240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Creating A Backup & Recovery Strategy

I need to create a backup and recovery strategy for SQL
Server 2000 but I'm not a DBA and I'm not very familiar
with SQL Server.
Here is what I would like to do.
1. I want to back up all the databases on the server at
the same time (i.e. I don't want to do each database
individually).
2. I want to schedule automatic backups.
3. I amy need to restore some or all of the databases on
the server.
4. I may need to restore all the databases to a different
server (the new server would have the same setup as the
old server).
5. It doesn't matter whether the backup is done in
Enterprise Manager or by using SQL commands.
Any advice would be appreciated.Create a Database Maintenance Plan using the wizard...set the backup
location to a drive not on your server (use UNC path). Tape is also an
option, but I never use that...too many tapes have failed on me.
You have options in the wizard for scheduling, data base integrity checks,
etc. What you choose in these options will depend on your databases and how
"recoverable" you need them to be.
I strongly recommend doing a little reading in Books Online before you get
started.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
> I need to create a backup and recovery strategy for SQL
> Server 2000 but I'm not a DBA and I'm not very familiar
> with SQL Server.
> Here is what I would like to do.
> 1. I want to back up all the databases on the server at
> the same time (i.e. I don't want to do each database
> individually).
> 2. I want to schedule automatic backups.
> 3. I amy need to restore some or all of the databases on
> the server.
> 4. I may need to restore all the databases to a different
> server (the new server would have the same setup as the
> old server).
> 5. It doesn't matter whether the backup is done in
> Enterprise Manager or by using SQL commands.
> Any advice would be appreciated.
>|||I'm having trouble finding detailed information on
restoring databases. I've found directions for restoring
databases in Enterprise Manager but those directions only
apply if the database is already on the server. I'm
looking for database recovery information for the
following scenario:
1. The database server, for whatever reason, is unusable.
2. I build a new database server.
3. I have to copy the database backups to the new server.
How do I restore a database in Enterprise Manager if the
database never existed on the server before?
Thanks in advance.
>--Original Message--
>Create a Database Maintenance Plan using the
wizard...set the backup
>location to a drive not on your server (use UNC path).
Tape is also an
>option, but I never use that...too many tapes have failed
on me.
>You have options in the wizard for scheduling, data base
integrity checks,
>etc. What you choose in these options will depend on
your databases and how
>"recoverable" you need them to be.
>I strongly recommend doing a little reading in Books
Online before you get
>started.
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Evan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
>> I need to create a backup and recovery strategy for SQL
>> Server 2000 but I'm not a DBA and I'm not very familiar
>> with SQL Server.
>> Here is what I would like to do.
>> 1. I want to back up all the databases on the server at
>> the same time (i.e. I don't want to do each database
>> individually).
>> 2. I want to schedule automatic backups.
>> 3. I amy need to restore some or all of the databases on
>> the server.
>> 4. I may need to restore all the databases to a
different
>> server (the new server would have the same setup as the
>> old server).
>> 5. It doesn't matter whether the backup is done in
>> Enterprise Manager or by using SQL commands.
>> Any advice would be appreciated.
>
>.
>|||Right-click databases, All tasks, restore database. Type in the name you
want to restore and fill in all the other blanks.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:027401c39f36$8ecd1080$a601280a@.phx.gbl...
> I'm having trouble finding detailed information on
> restoring databases. I've found directions for restoring
> databases in Enterprise Manager but those directions only
> apply if the database is already on the server. I'm
> looking for database recovery information for the
> following scenario:
> 1. The database server, for whatever reason, is unusable.
> 2. I build a new database server.
> 3. I have to copy the database backups to the new server.
> How do I restore a database in Enterprise Manager if the
> database never existed on the server before?
> Thanks in advance.
> >--Original Message--
> >Create a Database Maintenance Plan using the
> wizard...set the backup
> >location to a drive not on your server (use UNC path).
> Tape is also an
> >option, but I never use that...too many tapes have failed
> on me.
> >
> >You have options in the wizard for scheduling, data base
> integrity checks,
> >etc. What you choose in these options will depend on
> your databases and how
> >"recoverable" you need them to be.
> >
> >I strongly recommend doing a little reading in Books
> Online before you get
> >started.
> >
> >--
> >Kevin Hill
> >President
> >3NF Consulting
> >
> >www.3nf-inc.com/NewsGroups.htm
> >
> >"Evan" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:016901c39f19$9b7a05d0$a401280a@.phx.gbl...
> >> I need to create a backup and recovery strategy for SQL
> >> Server 2000 but I'm not a DBA and I'm not very familiar
> >> with SQL Server.
> >>
> >> Here is what I would like to do.
> >> 1. I want to back up all the databases on the server at
> >> the same time (i.e. I don't want to do each database
> >> individually).
> >> 2. I want to schedule automatic backups.
> >> 3. I amy need to restore some or all of the databases on
> >> the server.
> >> 4. I may need to restore all the databases to a
> different
> >> server (the new server would have the same setup as the
> >> old server).
> >> 5. It doesn't matter whether the backup is done in
> >> Enterprise Manager or by using SQL commands.
> >>
> >> Any advice would be appreciated.
> >>
> >
> >
> >.
> >