Mark Forums Read

Moving system datbases on cluster

Go Back

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

Reply

Page 1 of 3

1

#1

Old

Russell

Posts: n/a

Moving system datbases on cluster - 07-02-2008 , 05:57 AM

I am just determining the necessary steps to move the system datbases that I
have on an Active/Passive cluster. I found the process to do this on a
standalone SQL Server.

What I don't know how to do is start SQL Server with the /f and /T3608. In
the process I have found it says you can just use NET START MSSQLSERVER /f
/T3608, but as I understand it all this would do would be to make the cluster
failover to the passive node.

How should I add these parameters on my cluster?

Reply With Quote

#2

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#3

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#4

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#5

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#6

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#7

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#8

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#9

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

Reply With Quote

#10

Old

Luca Bianchi

Posts: n/a

Re: Moving system datbases on cluster - 07-02-2008 , 07:13 AM

Quote:

How should I add these parameters on my cluster?

In a clustered instance (and on a standalone instance too) you have to put
these startup parameter in SQL Server Configuration Manager.
In "SQL Server 2005 Services" section right click the "SQL Server (instance
name)" icon... Properties... and then in the "Advanced" tab there is
"Startup Parameters".

Bye

--
Luca Bianchi
Microsoft MVP - SQL Server
http://community.ugiss.org/blogs/lbianchi

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.