Mark Forums Read

Restoring My Database

Go Back

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Reply

Page 1 of 3

1

#1

Old

Leila

Posts: n/a

Restoring My Database - 03-02-2008 , 05:49 AM

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers? How
is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#2

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#3

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#4

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#5

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#6

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#7

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#8

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#9

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

#10

Old

Uri Dimant

Posts: n/a

Re: Restoring My Database - 03-02-2008 , 07:01 AM

Leila
You restore database on the node that hostes SQL Server instance.

"Leila" <Leilas (AT) hotpop (DOT) com> wrote

Quote:

Hi,
We have just setup two servers (SQL2K) in Active/Passive clustered
environment on Windows Server 2003. Now I need to restore my database from
the most recent backup. Should I restore it on Active node like before or
there are special considerations for restoring on clustered SQL Servers?
How is the Passive node informed about this newly restored database?
Many thanks in advance,
Leila

Reply With Quote

Reply

Page 1 of 3

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.