Restrict delete from a table

Hi

I need to restrict delete from one table by any user of SQL. How can we do this? This is our master table and we dont want any one to delete data from this table.

Thanks
BalaTry Cascade ON DELETE NO ACTION, you can use either code or set it on the table properties. Run a search for Cascade Delete in the BOL(books online) for more examples. NO ACTION is an ANSI SQL DRI(Declarative Referential Integrity) rule that prevents Deletes from tables. Hope this helps

CREATE TABLE order_part
(order_nmbr int,
part_nmbr int
FOREIGN KEY REFERENCES part_sample(part_nmbr)
ON DELETE NO ACTION,
qty_ordered int)
GO

Kind regards,
Gift Peddie

restoring with StopBeforeMark

hi
i did :
create table pp ( id int )
backup full
insert into pp values ( 1 )
backup diff
insert into pp values ( 2 )
backup log 1
insert into pp values ( 3 )
backup log 2
insert into pp values ( 4 )
backup log 3 -- tail
i want to restore
the rows 1, 2, and 3
the way i'm trying is this :
restore database [xx] from TheBackUp with
NOrecovery,
StopBeforeMark= 'LSN of backup log 4'
but,
i get a table with no rows
what is wrong ?
TIA
atte,
Hernn
atte,
Hernn
ohhhh...
i understand now...
i have to restore
the whole the backup chain
from the first to the last
but using the StopBeforeClause...
is there a way to restore
the whole backup chain in one line ?
should i to write a "loop"
for restore each row
that RESTORE HEADERONLY bring me ?
atte,
Hernn
"bajopalabra" <bajopalabra@.hotmail.com> escribi en el mensaje
news:%23kiu9On3GHA.696@.TK2MSFTNGP03.phx.gbl...
| hi
| i did :
|
| create table pp ( id int )
| backup full
| insert into pp values ( 1 )
| backup diff
| insert into pp values ( 2 )
| backup log 1
| insert into pp values ( 3 )
| backup log 2
| insert into pp values ( 4 )
| backup log 3 -- tail
|
| i want to restore
| the rows 1, 2, and 3
|
| the way i'm trying is this :
|
| restore database [xx] from TheBackUp with
| NOrecovery,
| StopBeforeMark= 'LSN of backup log 4'
|
| but,
| i get a table with no rows
|
| what is wrong ?
|
| TIA
|
| --
| atte,
| Hernn
|
| --
| atte,
| Hernn
|
|
|||Already replied in .programming. Please don't multi-post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:uVMa5gn3GHA.4976@.TK2MSFTNGP02.phx.gbl...
> ohhhh...
> i understand now...
> i have to restore
> the whole the backup chain
> from the first to the last
> but using the StopBeforeClause...
> is there a way to restore
> the whole backup chain in one line ?
> should i to write a "loop"
> for restore each row
> that RESTORE HEADERONLY bring me ?
> --
> atte,
> Hernn
> "bajopalabra" <bajopalabra@.hotmail.com> escribi en el mensaje
> news:%23kiu9On3GHA.696@.TK2MSFTNGP03.phx.gbl...
> | hi
> | i did :
> |
> | create table pp ( id int )
> | backup full
> | insert into pp values ( 1 )
> | backup diff
> | insert into pp values ( 2 )
> | backup log 1
> | insert into pp values ( 3 )
> | backup log 2
> | insert into pp values ( 4 )
> | backup log 3 -- tail
> |
> | i want to restore
> | the rows 1, 2, and 3
> |
> | the way i'm trying is this :
> |
> | restore database [xx] from TheBackUp with
> | NOrecovery,
> | StopBeforeMark= 'LSN of backup log 4'
> |
> | but,
> | i get a table with no rows
> |
> | what is wrong ?
> |
> | TIA
> |
> | --
> | atte,
> | Hernn
> |
> | --
> | atte,
> | Hernn
> |
> |
>

restoring with StopBeforeMark

hi
i did :
create table pp ( id int )
backup full
insert into pp values ( 1 )
backup diff
insert into pp values ( 2 )
backup log 1
insert into pp values ( 3 )
backup log 2
insert into pp values ( 4 )
backup log 3 -- tail
i want to restore
the rows 1, 2, and 3
the way i'm trying is this :
restore database [xx] from TheBackUp with
NOrecovery,
StopBeforeMark= 'LSN of backup log 4'
but,
i get a table with no rows
what is wrong '
TIA
atte,
Hernn
atte,
Hernnohhhh...
i understand now...
i have to restore
the whole the backup chain
from the first to the last
but using the StopBeforeClause...
is there a way to restore
the whole backup chain in one line ?
should i to write a "loop"
for restore each row
that RESTORE HEADERONLY bring me '
atte,
Hernn
"bajopalabra" <bajopalabra@.hotmail.com> escribi en el mensaje
news:%23kiu9On3GHA.696@.TK2MSFTNGP03.phx.gbl...
| hi
| i did :
|
| create table pp ( id int )
| backup full
| insert into pp values ( 1 )
| backup diff
| insert into pp values ( 2 )
| backup log 1
| insert into pp values ( 3 )
| backup log 2
| insert into pp values ( 4 )
| backup log 3 -- tail
|
| i want to restore
| the rows 1, 2, and 3
|
| the way i'm trying is this :
|
| restore database [xx] from TheBackUp with
| NOrecovery,
| StopBeforeMark= 'LSN of backup log 4'
|
| but,
| i get a table with no rows
|
| what is wrong '
|
| TIA
|
| --
| atte,
| Hernn
|
| --
| atte,
| Hernn
|
||||Already replied in .programming. Please don't multi-post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bajopalabra" <bajopalabra@.hotmail.com> wrote in message
news:uVMa5gn3GHA.4976@.TK2MSFTNGP02.phx.gbl...
> ohhhh...
> i understand now...
> i have to restore
> the whole the backup chain
> from the first to the last
> but using the StopBeforeClause...
> is there a way to restore
> the whole backup chain in one line ?
> should i to write a "loop"
> for restore each row
> that RESTORE HEADERONLY bring me '
> --
> atte,
> Hernn
> "bajopalabra" <bajopalabra@.hotmail.com> escribi en el mensaje
> news:%23kiu9On3GHA.696@.TK2MSFTNGP03.phx.gbl...
> | hi
> | i did :
> |
> | create table pp ( id int )
> | backup full
> | insert into pp values ( 1 )
> | backup diff
> | insert into pp values ( 2 )
> | backup log 1
> | insert into pp values ( 3 )
> | backup log 2
> | insert into pp values ( 4 )
> | backup log 3 -- tail
> |
> | i want to restore
> | the rows 1, 2, and 3
> |
> | the way i'm trying is this :
> |
> | restore database [xx] from TheBackUp with
> | NOrecovery,
> | StopBeforeMark= 'LSN of backup log 4'
> |
> | but,
> | i get a table with no rows
> |
> | what is wrong '
> |
> | TIA
> |
> | --
> | atte,
> | Hernn
> |
> | --
> | atte,
> | Hernn
> |
> |
>

Restoring SQL Server Databases after uninstalling and reinstalling SQL Server.

Hi

I have another question : 1) Restoring SQL Server Databases after uninstalling and reinstalling SQL Server.

Two days ago there was some problem with Norton Antivirus, so Windows 98 restored itself to a previous state. The SQL Server name was not available when I tried to start again, so I had to uninstall and reinstall SQL Server. I started a new Database just a week before this happened (the change from Access to SQL Server as I stated in the other thread http://www.dbforums.com/showthread.php?threadid=987880) and after reinstallation I could not access the Database any more - even while it is in the Data directory. I did not have any backup to restore from - I just started creating tables, so there was only the Log file created and the MDF database file. I tried to import it for a while to the new server, but as the database is not shown in the new server, it was unable to import like I hoped. So how do you restore it back to SQL Server when you have no backup and only the (undamaged) MDF database file if you only have one server? I had to recreate the Database from scratch again - I don't want it to happen again.

Regards

CornYou might be able to reattach the database. Since I assume that SQL Server did a normal shut-down before SQL was uninstalled, the files should have quiessed normally.

Note that this is somewhat risky, but it is probably better than nothing. Make a backup copy of the files before you try to attach them. Make a second backup of the database if/when you attach it. Pray a lot during the process ;)

-PatP|||So how do you reattach the Database, I don't know what you are talking about. When I uninstallled, the directory was C:\Program Files\MSSQL7, but when I reinstalled it, I left it the default C:\MSSQL7 directory. Can this be the problem that the new server don't see the old database, because if this is the reason, then Im confused - well I'm confused already!|||look up sp_attach_db in bol, it's actually straight forward.|||I'd use sp_attach_db (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp), but there is also SQL Enterprise Mangler (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp) for the script-challenged.

-PatPsql

Restoring sql server 7.0 database into sql server 2005 express - problem!

Hi!

I'm a beginner w ith SQL Express and am having some problems. I am using 2005 SP1 and installed the SQL Server Management Studio Express as well. I have a backup from a SQL Server 7.0 database that I am trying to restore into my database using the management studio. When I try to restore from the file into my database, I get the error,

System.Data.SqlClient.SqlError: The backup of the system database on the device D:\GMBeta2Local.bak cannot be restored because it was created by a different version of the server (7.00.1063) than this server (9.00.3033). (Microsoft.SqlServer.Express.Smo)

Is this true? Is there any way for me to get this data into my SQL Server 2005 express on my laptop?

hi,

thi message is usually raised when a system database is tried to be restored across different SQL Server versions, as reported in http://support.microsoft.com/kb/264474/en-us..

you should only "upgrade" user's databases..

regards

Restoring SQL 6.5 DBs

Hi
I am trying to restore several databases to a single server due to restricti
ons on hardware. Each server had previously had a database that was named ex
actly the same on each server. Therefore, the new instances will be appended
with an appropriate suffix
to distinguish it from the already existing database on the server.
The problem is actually trying to restore the first database. I have created
a new database and named it accordingly. I have a backup of the database I
want to restore to this server. When I try and restore it by entering the pa
th of the .dat file, the 'r
estore now' option is not highlighted.
Can anyone help point me in the right direction.
Many thanks
KalpeshHi Kalpesh,
Not sure what happend with Enterprise manager. The "Restore Now" button will
be enabled only after you
select the destination database , "Add file" button , and select the
correct backup file to restore and click "close".
(Now the Restore Now button will be enabled)...
ISQL_W
--
Why dont you try executing the below command to restore the database from
ISQL_W .
LOAD Database <dbname> from disk='C:\backup\dbname.DMP' with stats=10
(Do the same step for all the databases)
Note:
1. Change the file name and directory based on your requirement.
2. Ensure that SQL 6.5 is patched with SP5a + SP5a Post update
Thanks
Hari
MCDBA
"Kalpesh" <kalpeshvaghela@.eu.spherion.com> wrote in message
news:F1798555-BB00-435F-A9E2-AE546950EAFF@.microsoft.com...
> Hi
> I am trying to restore several databases to a single server due to
restrictions on hardware. Each server had previously had a database that was
named exactly the same on each server. Therefore, the new instances will be
appended with an appropriate suffix to distinguish it from the already
existing database on the server.
> The problem is actually trying to restore the first database. I have
created a new database and named it accordingly. I have a backup of the
database I want to restore to this server. When I try and restore it by
entering the path of the .dat file, the 'restore now' option is not
highlighted.
> Can anyone help point me in the right direction.
> Many thanks
> Kalpesh

Restoring SQL 6.5 DBs

Hi
I am trying to restore several databases to a single server due to restrictions on hardware. Each server had previously had a database that was named exactly the same on each server. Therefore, the new instances will be appended with an appropriate suffix
to distinguish it from the already existing database on the server.
The problem is actually trying to restore the first database. I have created a new database and named it accordingly. I have a backup of the database I want to restore to this server. When I try and restore it by entering the path of the .dat file, the 'r
estore now' option is not highlighted.
Can anyone help point me in the right direction.
Many thanks
Kalpesh
Hi Kalpesh,
Not sure what happend with Enterprise manager. The "Restore Now" button will
be enabled only after you
select the destination database , "Add file" button , and select the
correct backup file to restore and click "close".
(Now the Restore Now button will be enabled)...
ISQL_W
Why dont you try executing the below command to restore the database from
ISQL_W .
LOAD Database <dbname> from disk='C:\backup\dbname.DMP' with stats=10
(Do the same step for all the databases)
Note:
1. Change the file name and directory based on your requirement.
2. Ensure that SQL 6.5 is patched with SP5a + SP5a Post update
Thanks
Hari
MCDBA
"Kalpesh" <kalpeshvaghela@.eu.spherion.com> wrote in message
news:F1798555-BB00-435F-A9E2-AE546950EAFF@.microsoft.com...
> Hi
> I am trying to restore several databases to a single server due to
restrictions on hardware. Each server had previously had a database that was
named exactly the same on each server. Therefore, the new instances will be
appended with an appropriate suffix to distinguish it from the already
existing database on the server.
> The problem is actually trying to restore the first database. I have
created a new database and named it accordingly. I have a backup of the
database I want to restore to this server. When I try and restore it by
entering the path of the .dat file, the 'restore now' option is not
highlighted.
> Can anyone help point me in the right direction.
> Many thanks
> Kalpesh

Restoring SQL 2000 Database from Cluster Config to Standalone

Hi
I have a tech question relating to SQL 2000
If I had a 2 node cluster of SQL , are there any implications/restrictions
in restoring the Database to another Domain / Server which is a SINGLE non
clustered server?
Many thanks!The database knows nothing of if it is or ever was in a clustered server or
not. So the answer is that there should be no problems related to the fact
it was in a clustered server when the backup was taken.
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> Hi
> I have a tech question relating to SQL 2000
> If I had a 2 node cluster of SQL , are there any implications/restrictions
> in restoring the Database to another Domain / Server which is a SINGLE non
> clustered server?
> Many thanks!|||So the domain also will not matter?...SQL will function if I was to restore
it on a Server that was in another WOrkgroup and not even a domain; like the
original?
"Andrew J. Kelly" wrote:

> The database knows nothing of if it is or ever was in a clustered server o
r
> not. So the answer is that there should be no problems related to the fac
t
> it was in a clustered server when the backup was taken.
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
>
>|||Again the database itself knows nothing of these things. The SQL Server
instance that you restore the db to has to deal with the OS and such. I
assume you already have that working since all you asked about was restoring
a db to another server. You may have to deal with a Login to db User
mismatch depending on the conditions but that may be true even if you
restored it on the same server. See if these help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...[vbcol=seagreen]
> So the domain also will not matter?...SQL will function if I was to
> restore
> it on a Server that was in another WOrkgroup and not even a domain; like
> the
> original?
> "Andrew J. Kelly" wrote:
>|||Many thanks Andrew! Appreciate the response!
"Andrew J. Kelly" wrote:

> Again the database itself knows nothing of these things. The SQL Server
> instance that you restore the db to has to deal with the OS and such. I
> assume you already have that working since all you asked about was restori
ng
> a db to another server. You may have to deal with a Login to db User
> mismatch depending on the conditions but that may be true even if you
> restored it on the same server. See if these help:
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/feat...cle.php/3379901 Movin
g
> system DB's
> http://www.support.microsoft.com/?id=314546 Moving DB's between Server
s
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Database
s
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.sqlservercentral.com/col...
ses.asp
> Moving Users
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permissi
on
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
>
>

Restoring SQL 2000 Database from Cluster Config to Standalone

Hi
I have a tech question relating to SQL 2000
If I had a 2 node cluster of SQL , are there any implications/restrictions
in restoring the Database to another Domain / Server which is a SINGLE non
clustered server?
Many thanks!
The database knows nothing of if it is or ever was in a clustered server or
not. So the answer is that there should be no problems related to the fact
it was in a clustered server when the backup was taken.
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
> Hi
> I have a tech question relating to SQL 2000
> If I had a 2 node cluster of SQL , are there any implications/restrictions
> in restoring the Database to another Domain / Server which is a SINGLE non
> clustered server?
> Many thanks!
|||So the domain also will not matter?...SQL will function if I was to restore
it on a Server that was in another WOrkgroup and not even a domain; like the
original?
"Andrew J. Kelly" wrote:

> The database knows nothing of if it is or ever was in a clustered server or
> not. So the answer is that there should be no problems related to the fact
> it was in a clustered server when the backup was taken.
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:10C5AB6D-125C-4023-8018-52D126CACFA8@.microsoft.com...
>
>
|||Again the database itself knows nothing of these things. The SQL Server
instance that you restore the db to has to deal with the OS and such. I
assume you already have that working since all you asked about was restoring
a db to another server. You may have to deal with a Login to db User
mismatch depending on the conditions but that may be true even if you
restored it on the same server. See if these help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...[vbcol=seagreen]
> So the domain also will not matter?...SQL will function if I was to
> restore
> it on a Server that was in another WOrkgroup and not even a domain; like
> the
> original?
> "Andrew J. Kelly" wrote:
|||Many thanks Andrew! Appreciate the response!
"Andrew J. Kelly" wrote:

> Again the database itself knows nothing of these things. The SQL Server
> instance that you restore the db to has to deal with the OS and such. I
> assume you already have that working since all you asked about was restoring
> a db to another server. You may have to deal with a Login to db User
> mismatch depending on the conditions but that may be true even if you
> restored it on the same server. See if these help:
>
> http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
> http://www.databasejournal.com/featu...le.php/3379901 Moving
> system DB's
> http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.sqlservercentral.com/colu...rdatabases.asp
> Moving Users
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scri...p?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay" <Jay@.discussions.microsoft.com> wrote in message
> news:F8C4F023-1F1E-4CF1-ACA0-6E0D0212C18C@.microsoft.com...
>
>
sql

restoring msdb**

Hi
I restored msdb database successfully,
because of changing
the server and needed to restore all jobs
have been schaduled for periodical backup all
user batabases.
but when I want to change the text of step1
of every job to new drive in a new server
following error happened:
""
why? what's wrong?
any help would be greatly appreciated.
RM,
Do you get an error number?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RM wrote:
> Hi
> I restored msdb database successfully,
> because of changing
> the server and needed to restore all jobs
> have been schaduled for periodical backup all
> user batabases.
> but when I want to change the text of step1
> of every job to new drive in a new server
> following error happened:
> ""
> why? what's wrong?
> any help would be greatly appreciated.
|||Also check SQL server error log and SQLAgent log for complete information on this behaviour.
--
Satya SKJ
"Mark Allison" wrote:

> RM,
> Do you get an error number?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:
>
|||yeah,
error 14274
On Mon, 12 Jul 2004 11:32:16 +0100, Mark Allison
<marka@.no.tinned.meat.mvps.org> wrote:
[vbcol=seagreen]
> RM,
> Do you get an error number?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:
|||RM, I don't know why your error message text is not showing but it
should be this:
"Error 14274: Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server."
This means that the server has been renamed and the originating_server
column in the sysjobs table is referencing the old server name. Update
sysjobs and it should be fine.
Use this proc to do the rename:
http://sqldev.net/download/sqlagent/...ent_rename.sql
This proc assumes that @.@.SERVERNAME is correct, you might want to check
that first, and correct it if it's wrong using sp_dropserver, sp_addserver
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RM wrote:
> yeah,
> error 14274
> On Mon, 12 Jul 2004 11:32:16 +0100, Mark Allison
> <marka@.no.tinned.meat.mvps.org> wrote:
>
>
|||thanks alot,
I was suprised ,very useful help**
On Tue, 13 Jul 2004 09:24:57 +0100, Mark Allison
<marka@.no.tinned.meat.mvps.org> wrote:
[vbcol=seagreen]
> RM, I don't know why your error message text is not showing but it
> should be this:
> "Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules) that originated from an MSX server."
> This means that the server has been renamed and the originating_server
> column in the sysjobs table is referencing the old server name. Update
> sysjobs and it should be fine.
> Use this proc to do the rename:
> http://sqldev.net/download/sqlagent/...ent_rename.sql
> This proc assumes that @.@.SERVERNAME is correct, you might want to check
> that first, and correct it if it's wrong using sp_dropserver,
> sp_addserver
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:

restoring msdb**

Hi
I restored msdb database successfully,
because of changing
the server and needed to restore all jobs
have been schaduled for periodical backup all
user batabases.
but when I want to change the text of step1
of every job to new drive in a new server
following error happened:
""
why? what's wrong?
any help would be greatly appreciated.RM,
Do you get an error number?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RM wrote:
> Hi
> I restored msdb database successfully,
> because of changing
> the server and needed to restore all jobs
> have been schaduled for periodical backup all
> user batabases.
> but when I want to change the text of step1
> of every job to new drive in a new server
> following error happened:
> ""
> why? what's wrong?
> any help would be greatly appreciated.|||Also check SQL server error log and SQLAgent log for complete information on
this behaviour.
--
--
Satya SKJ
"Mark Allison" wrote:

> RM,
> Do you get an error number?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:
>|||yeah,
error 14274
On Mon, 12 Jul 2004 11:32:16 +0100, Mark Allison
<marka@.no.tinned.meat.mvps.org> wrote:
[vbcol=seagreen]
> RM,
> Do you get an error number?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:|||RM, I don't know why your error message text is not showing but it
should be this:
"Error 14274: Cannot add, update, or delete a job (or its steps or
schedules) that originated from an MSX server."
This means that the server has been renamed and the originating_server
column in the sysjobs table is referencing the old server name. Update
sysjobs and it should be fine.
Use this proc to do the rename:
http://sqldev.net/download/sqlagent...gent_rename.sql
This proc assumes that @.@.SERVERNAME is correct, you might want to check
that first, and correct it if it's wrong using sp_dropserver, sp_addserver
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RM wrote:
> yeah,
> error 14274
> On Mon, 12 Jul 2004 11:32:16 +0100, Mark Allison
> <marka@.no.tinned.meat.mvps.org> wrote:
>
>|||thanks alot,
I was suprised ,very useful help**
On Tue, 13 Jul 2004 09:24:57 +0100, Mark Allison
<marka@.no.tinned.meat.mvps.org> wrote:
[vbcol=seagreen]
> RM, I don't know why your error message text is not showing but it
> should be this:
> "Error 14274: Cannot add, update, or delete a job (or its steps or
> schedules) that originated from an MSX server."
> This means that the server has been renamed and the originating_server
> column in the sysjobs table is referencing the old server name. Update
> sysjobs and it should be fine.
> Use this proc to do the rename:
> http://sqldev.net/download/sqlagent...gent_rename.sql
> This proc assumes that @.@.SERVERNAME is correct, you might want to check
> that first, and correct it if it's wrong using sp_dropserver,
> sp_addserver
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> RM wrote:

Restoring master and msdb on a different server

Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
OskarCan you do it? Sure. Is it a good idea or not? That depends on why you
would want to do it. What are you trying to accomplish?
Also, the weaker machine, you said, is only a 2-way CPU box, why would you
have a 2 CPU affinity set on it?
Sincerely,
Anthony Thomas
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manne
r.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and i
t
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>

Restoring master and msdb on a different server

Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar
Can you do it? Sure. Is it a good idea or not? That depends on why you
would want to do it. What are you trying to accomplish?
Also, the weaker machine, you said, is only a 2-way CPU box, why would you
have a 2 CPU affinity set on it?
Sincerely,
Anthony Thomas

"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
Hi
I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
Server 2003 SP1 and MS SQL Server 2000 SP3.
The SQL Server on the weaker machine has affinity mask turned on to use
only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
located on drive E:.
The SQL Server on the stronger machine has master and msdb located on
drive C:, affinity mask set off, and dynamic memory allocation set on.
Can I restore the master database from the weaker machine on the stronger
machine and is it a good idea?
Many thanks,
Oskar
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>
|||I was hoping that this would be an easier way to migrate the SQL Server
information (e.g. logins, jobs etc.) from the weaker server to the stronger
one. But then when I started to think of moving the data files of master and
msdb databases, I wasn't sure if I that would be possible in the usual manner.
I have the affinity set on the weaker server so that only one logical CPU on
each of the physical Xeon CPUs employed. This is because the Windows 2000
Server can't tell the difference between the logical and physical CPUs and it
can assign an additinal thread to a busy CPU.
By now I have already accomplished the migration using the script transfer
approach.
Many thanks,
Oskar
"Anthony Thomas" wrote:

> Can you do it? Sure. Is it a good idea or not? That depends on why you
> would want to do it. What are you trying to accomplish?
> Also, the weaker machine, you said, is only a 2-way CPU box, why would you
> have a 2 CPU affinity set on it?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Oskar" <Oskar@.discussions.microsoft.com> wrote in message
> news:5DEC7960-CE31-4F0F-815F-E7B75BD3CFA4@.microsoft.com...
> Hi
> I have two machines one of which is 2 CPU, 3.5 GB RAM, HP Proliant DL 380
> G3 with MS Windows 2000 Advanced Server SP4 and MS SQL Server 2000 SP3 on
> it, the other - 4 CPU, 4 GB RAM, HP Proliant DL 580 G3 with MS Windows
> Server 2003 SP1 and MS SQL Server 2000 SP3.
> The SQL Server on the weaker machine has affinity mask turned on to use
> only 2 CPUs, dynamic memory allocation set on, master, and msdb databases
> located on drive E:.
> The SQL Server on the stronger machine has master and msdb located on
> drive C:, affinity mask set off, and dynamic memory allocation set on.
> Can I restore the master database from the weaker machine on the stronger
> machine and is it a good idea?
> --
> Many thanks,
> Oskar
>
>

restoring db**

Hi
I restore my db backup in different station by following the same steps .but
in some of
them it restores successfully and in the others folowing error appearred.
(my db is in
full recovery model and it's backup size is about 450mg and it's .mdf and
..ldf files
are about 450mg and 6gig in order)
error:
"modify file encountered operationg system error 112 (error not found) while
attemting
to exapand the physical file. could not create one or more files.consider
using the
with move option to modify while location restore database is terminating
abnormally."
I checked the destination if it's correct or not and the enough space(about
10gig is
free on destination drive) but still above error happenned.any help would be
greatly
thankful.
> Hi
> I restore my db backup in different station by following the same steps
.but
> in some of
> them it restores successfully and in the others folowing error appearred.
> (my db is in
> full recovery model and it's backup size is about 450mg and it's .mdf and
> .ldf files
> are about 450mg and 6gig in order)
> error:
> "modify file encountered operationg system error 112 (error not found)
while
> attemting
> to exapand the physical file. could not create one or more files.consider
> using the
> with move option to modify while location restore database is terminating
> abnormally."
> I checked the destination if it's correct or not and the enough
space(about
> 10gig is
> free on destination drive) but still above error happenned.any help would
be
> greatly
> thankful.
Operating system error 112 means "not enough diskspace." Make sure that you
are not using COMPRESSED VOLUMES.
Hope this helps,
Eric Crdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.