Hi,
I am having a problem when I try to move resource (sql server service) from
one group to another. Moving other resources works fine but not SQL. I have
two SQL server s 2000 sp3a on two win 2003 servers on an active/passive
mode.
I got two error messages:
"Cluster resource SQL Server (inst01) timed out. If the pending timeout is
too short for this resource, consider increasing the pending timeout value"
"Cluster resource 'SQL Server(insto1)' in Resource Group "GroupSqlServer"
failed"
Any idea why this happen?
many thanks,
Miguel
So, you are running two instances on a single node, using the second node
merely as a warm standby server?
May I ask how much memory you have installed on this system and how much is
allocated to each SQL Server instance?
Also, are you using AWE configuration?
A couple of things, when you move resources, you are telling SQL Server to
come offline. It must checkpoint the system. If the system is active,
there will be a lot of dirty data pages that must be flushed to stable
media. Furthermore, if you are running AWE, then when SQL Sever comes
offline, not only do dirty data pages must be flushed, SQL Server will also
"zerro-out" the AWE memory as well. If this of any appreciable size, this
will also take some additional time.
To fix the problem, increase the Pending Timeout value in the SQL Server
cluster resource to avoid the failure. Basically speaking, this is normal
activity for a large and/or busy system.
FIX: The SQL Server cluster resource may be marked as Fail when you try to
take it offline
http://support.microsoft.com/default...b;en-us;834923
AWE-Enabled SQL Server 2000 May Take a Long Time to Start
http://support.microsoft.com/default...b;en-us;329914
Sincerely,
Anthony Thomas
"Miguel Henriques" <miguel.henriques@.gmail.com> wrote in message
news:ODkeXTgvFHA.1560@.TK2MSFTNGP09.phx.gbl...
Hi,
I am having a problem when I try to move resource (sql server service) from
one group to another. Moving other resources works fine but not SQL. I have
two SQL server s 2000 sp3a on two win 2003 servers on an active/passive
mode.
I got two error messages:
"Cluster resource SQL Server (inst01) timed out. If the pending timeout is
too short for this resource, consider increasing the pending timeout value"
"Cluster resource 'SQL Server(insto1)' in Resource Group "GroupSqlServer"
failed"
Any idea why this happen?
many thanks,
Miguel
Showing posts with label moving. Show all posts
Showing posts with label moving. Show all posts
Friday, March 9, 2012
Error moving SQL Express 2005 Database to other folder / computer
When we try to move a SQL Express 2005 database to another folder in the same
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this ?
Thanks for any help.
Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this ?
>
> Thanks for any help.
>
>
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this ?
Thanks for any help.
Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this ?
>
> Thanks for any help.
>
>
Error moving SQL Express 2005 Database to other folder / computer
When we try to move a SQL Express 2005 database to another folder in the sam
e
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the s
ame
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database
to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of t
he
> database.
> How to solve this '
>
> Thanks for any help.
>
>
e
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the s
ame
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database
to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of t
he
> database.
> How to solve this '
>
> Thanks for any help.
>
>
Error moving SQL Express 2005 Database to other folder / computer
When we try to move a SQL Express 2005 database to another folder in the same
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this '
>
> Thanks for any help.
>
>
computer or to other computer it only attach as read only.
Here is the procedure:
- Install SQL Express (I used a instance called SQL2005)
- Create or attach a database from other computer
- Detach the database (sp_detach_db)
- Copy files (mdf and ldf) to other folder
- Attach the database (sp_attach_db or create database for attach).
It will attach the database as readonly. If you try to use Alter Database to
change to read-write you receive an error.
This is only on the Express Edition. The same procedure works ok on the
developer copy download from MSDN.
The point is, I need to distribute this database to customers (they have
some data inside, so I cannot create then). I don't know what folder my
customers will use to install. And I cannot remove the readonly state of the
database.
How to solve this '
Thanks for any help.Hi
Just solved it.
The SQL Express installed with user "NetWork Service" not "LocalSystem" I
use in the other machine. I changed my command line to force LocalSystem and
it is now working.
"Gustavo Trunci" wrote:
> When we try to move a SQL Express 2005 database to another folder in the same
> computer or to other computer it only attach as read only.
> Here is the procedure:
> - Install SQL Express (I used a instance called SQL2005)
> - Create or attach a database from other computer
> - Detach the database (sp_detach_db)
> - Copy files (mdf and ldf) to other folder
> - Attach the database (sp_attach_db or create database for attach).
> It will attach the database as readonly. If you try to use Alter Database to
> change to read-write you receive an error.
> This is only on the Express Edition. The same procedure works ok on the
> developer copy download from MSDN.
> The point is, I need to distribute this database to customers (they have
> some data inside, so I cannot create then). I don't know what folder my
> customers will use to install. And I cannot remove the readonly state of the
> database.
> How to solve this '
>
> Thanks for any help.
>
>
Subscribe to:
Posts (Atom)