restoring SQL 2000 on Windows 2000

i am trying to restore sql 2000 on Windows 2000 from a
tape backup created thru Veritas 8.6. The restore
completes successfully and everything seems fine except
for the fact that the sql service fails to start and when
i try to start sql, it returns the error message "the path
was not found"I'm guessing that one of your parameters in the registry point to some
location different then where you restored the files. Review the registry
entries in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLSever\Parameters
Make sure all the parmeters poin to valid files, the ones you restore.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"malejandro" <malejandrdo@.armadillohomes.com> wrote in message
news:12d0401c44349$e884d6f0$a601280a@.phx
.gbl...
> i am trying to restore sql 2000 on Windows 2000 from a
> tape backup created thru Veritas 8.6. The restore
> completes successfully and everything seems fine except
> for the fact that the sql service fails to start and when
> i try to start sql, it returns the error message "the path
> was not found"

restoring SQL 2000 on Windows 2000

i am trying to restore sql 2000 on windows 2000 from a
tape backup created thru Veritas 8.6. The restore
completes successfully and everything seems fine except
for the fact that the sql service fails to start and when
i try to start sql, it returns the error message "the path
was not found"I'm guessing that one of your parameters in the registry point to some
location different then where you restored the files. Review the registry
entries in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSever\Parameters
Make sure all the parmeters poin to valid files, the ones you restore.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"malejandro" <malejandrdo@.armadillohomes.com> wrote in message
news:12d0401c44349$e884d6f0$a601280a@.phx.gbl...
> i am trying to restore sql 2000 on windows 2000 from a
> tape backup created thru Veritas 8.6. The restore
> completes successfully and everything seems fine except
> for the fact that the sql service fails to start and when
> i try to start sql, it returns the error message "the path
> was not found"

restoring SQL 2000 on Windows 2000

i am trying to restore sql 2000 on windows 2000 from a
tape backup created thru Veritas 8.6. The restore
completes successfully and everything seems fine except
for the fact that the sql service fails to start and when
i try to start sql, it returns the error message "the path
was not found"
I'm guessing that one of your parameters in the registry point to some
location different then where you restored the files. Review the registry
entries in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSever\P arameters
Make sure all the parmeters poin to valid files, the ones you restore.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"malejandro" <malejandrdo@.armadillohomes.com> wrote in message
news:12d0401c44349$e884d6f0$a601280a@.phx.gbl...
> i am trying to restore sql 2000 on windows 2000 from a
> tape backup created thru Veritas 8.6. The restore
> completes successfully and everything seems fine except
> for the fact that the sql service fails to start and when
> i try to start sql, it returns the error message "the path
> was not found"
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 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:
> > 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.
>|||yeah,
error 14274
On Mon, 12 Jul 2004 11:32:16 +0100, Mark Allison
<marka@.no.tinned.meat.mvps.org> 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:
>> 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, 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/sp_sqlagent_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:
>> 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.
>|||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:
> 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/sp_sqlagent_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:
>> 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.
>>

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 Cárdenas
Support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

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.