MSDE to MS SQL restore

I have a MSDE database that I am trying to restore into MS SQL 7.

I am running the following restore from Query Analyzer;

RESTORE DATABASE name
FROM DISK = 'c:\mssql7\backup\name_backup'

I am getting the following error

Server: Msg 3624, Level 20, State 1, Line 1

Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 7
Process ID: 748

Connection Broken

Is what I'm trying to do impossible or something I'm doing wrong. Any help would be much appreciatedI don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.|||Originally posted by machado
I don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.

I only have the backup file, I don't actually posess MSDE so as far as I know I can't actually connect to anything for a dts to work|||MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.|||Originally posted by machado
MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.

So it is :)

Thanks, I'm installing it nowsql

MSDE SQL Server marked as SUSPECT

Hello all! I have an instance of MSDE that is marked as SUSPECT. In
the error log I get:
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
Operating system error 3(The system cannot find the path specified.).
The statement is proceeding but is non-restartable.
We don't have Enteprise Manager to look any closer at the DB. Do any of
you have a suggestion as to how to get this DB operational?
Jason
Restore it from a known good backup.
Jim
"Jason Hunsberger" <systems182@.nospam_andersontech.com> wrote in message
news:u1ZDFhWDFHA.3020@.TK2MSFTNGP09.phx.gbl...
> Hello all! I have an instance of MSDE that is marked as SUSPECT. In the
> error log I get:
> I/O error on backup or restore restart-checkpoint file 'C:\Program
> Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
> Operating system error 3(The system cannot find the path specified.). The
> statement is proceeding but is non-restartable.
> We don't have Enteprise Manager to look any closer at the DB. Do any of
> you have a suggestion as to how to get this DB operational?
> Jason
sql

MSDE SQL Database Marked SUSPECT

Hello all! I have an instance of MSDE that is marked as SUSPECT. In
the error log I get:
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
Operating system error 3(The system cannot find the path specified.).
The statement is proceeding but is non-restartable.
We don't have Enteprise Manager to look any closer at the DB. Do any of
you have a suggestion as to how to get this DB operational?
Jason
Jason,
You might check with Veritas regarding the Backup Exec.. The 4IDR part of
the filenames may have to do with their Intelligent Disaster Recovery..
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Jason Hunsberger" <systems182@.nospam_andersontech.com> wrote in message
news:umOi6EWDFHA.208@.TK2MSFTNGP12.phx.gbl...
> Hello all! I have an instance of MSDE that is marked as SUSPECT. In
> the error log I get:
> I/O error on backup or restore restart-checkpoint file 'C:\Program
> Files\Microsoft SQL Server\MSSQL$SBSMONITORING\backup\model4IDR.ckp'.
> Operating system error 3(The system cannot find the path specified.).
> The statement is proceeding but is non-restartable.
> We don't have Enteprise Manager to look any closer at the DB. Do any of
> you have a suggestion as to how to get this DB operational?
> Jason

msde restore problem

Hi guys - hope you can help me.
We had a support request from a user today who wanted to know why some of
her data was missing. Upon investigation, it turns out that due to various
things... we'd had to image back the server. Now, we took a copy of the
directory with all the database files in before we did that. So we tried to
restore that today, and it said it had worked, but the data is still missing
!
Question.. if we restored the FILES of the database over themselves, as the
database was running, would we need to restart the sql server agent thingy?
Or should we do that first, restore the files, and then restart MSDE?
Would it make any difference? Or to be more precise, would overwriting the
files (its an open file restore, but it said it worked?) require msde to be
restarted?!
Cheers
Danmusosdev wrote:
> Hi guys - hope you can help me.
> We had a support request from a user today who wanted to know why some of
> her data was missing. Upon investigation, it turns out that due to various
> things... we'd had to image back the server. Now, we took a copy of the
> directory with all the database files in before we did that. So we tried t
o
> restore that today, and it said it had worked, but the data is still missi
ng!
> Question.. if we restored the FILES of the database over themselves, as th
e
> database was running, would we need to restart the sql server agent thingy
?
> Or should we do that first, restore the files, and then restart MSDE?
> Would it make any difference? Or to be more precise, would overwriting the
> files (its an open file restore, but it said it worked?) require msde to b
e
> restarted?!
> Cheers
>
> Dan
Oh for crying out loud, did you actually use the word "thingy"? Sure
sign of a competent tech.
You should have made a proper SQL backup, instead of trying to copy the
raw database files. Those files were in use, unless you stopped the
MSSQLSERVER service. You've most likely lost data.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi, Dan,
Thanks for your post!
And Thanks Tracy for your kind participation and good suggestions.
Dan, my understanding of this issue is:
The database lost data that might be caused by many reasons. You had a copy
of that database data directory and decided to restore the files of the
database over themselves. You wanted to know whether you need restart the
SQL Server Agent at first and whether the MSDE need to be restarted.
If I have misunderstood, please let me know.
Do you mean that your backup files are raw files (.mdf,.ldf) of the
database and not real backup files (.bak) ?
If they are .bak files, you can directly use the RESTORE statement to
restore the database.
Otherwise, you can take the following steps to replace the files without
stop the MSDE:
1) Backup your database by "BACKUP DATABASE database_name TO
DISK='D:\temp_folder\test.bak' "
2) Run the statement "sp_detach_db [database_name]"
3) Remove the database files in the local directory.
4) Copy the backup files to the directory
5) Use the statement sp_attach_db like this:
EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'
You may refer to:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Otherwise, are you sure that the backup files have no data loss? As Tracy
said, for time difference, they still possibly have lost data.
If you have any other concerns, please feel free to let me know. It's my
pleasure to be of assistance.
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others:
https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Dan,
Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.
Have a great day!
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others:
https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

msde restore problem

Hi guys - hope you can help me.
We had a support request from a user today who wanted to know why some of
her data was missing. Upon investigation, it turns out that due to various
things... we'd had to image back the server. Now, we took a copy of the
directory with all the database files in before we did that. So we tried to
restore that today, and it said it had worked, but the data is still missing!
Question.. if we restored the FILES of the database over themselves, as the
database was running, would we need to restart the sql server agent thingy?
Or should we do that first, restore the files, and then restart MSDE?
Would it make any difference? Or to be more precise, would overwriting the
files (its an open file restore, but it said it worked?) require msde to be
restarted?!
Cheers
Danmusosdev wrote:
> Hi guys - hope you can help me.
> We had a support request from a user today who wanted to know why some of
> her data was missing. Upon investigation, it turns out that due to various
> things... we'd had to image back the server. Now, we took a copy of the
> directory with all the database files in before we did that. So we tried to
> restore that today, and it said it had worked, but the data is still missing!
> Question.. if we restored the FILES of the database over themselves, as the
> database was running, would we need to restart the sql server agent thingy?
> Or should we do that first, restore the files, and then restart MSDE?
> Would it make any difference? Or to be more precise, would overwriting the
> files (its an open file restore, but it said it worked?) require msde to be
> restarted?!
> Cheers
>
> Dan
Oh for crying out loud, did you actually use the word "thingy"? Sure
sign of a competent tech.
You should have made a proper SQL backup, instead of trying to copy the
raw database files. Those files were in use, unless you stopped the
MSSQLSERVER service. You've most likely lost data.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi, Dan,
Thanks for your post!
And Thanks Tracy for your kind participation and good suggestions.
Dan, my understanding of this issue is:
The database lost data that might be caused by many reasons. You had a copy
of that database data directory and decided to restore the files of the
database over themselves. You wanted to know whether you need restart the
SQL Server Agent at first and whether the MSDE need to be restarted.
If I have misunderstood, please let me know.
Do you mean that your backup files are raw files (.mdf,.ldf) of the
database and not real backup files (.bak) ?
If they are .bak files, you can directly use the RESTORE statement to
restore the database.
Otherwise, you can take the following steps to replace the files without
stop the MSDE:
1) Backup your database by "BACKUP DATABASE database_name TO
DISK='D:\temp_folder\test.bak' "
2) Run the statement "sp_detach_db [database_name]"
3) Remove the database files in the local directory.
4) Copy the backup files to the directory
5) Use the statement sp_attach_db like this:
EXEC sp_attach_db @.dbname = N'pubs',
@.filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'
You may refer to:
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/?id=224071
Otherwise, are you sure that the backup files have no data loss? As Tracy
said, for time difference, they still possibly have lost data.
If you have any other concerns, please feel free to let me know. It's my
pleasure to be of assistance.
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Dan,
Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.
Have a great day!
+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.sql

MSDE over SQL 2005 accidentaly - how to restore SQL 2005?

Hello all!
I write this post on behalf of my colleagues so I don't know a full picture
but this is the situation:
On a Win 2k3 machine with a SQL Server 2005 installed, a colleague
mistakenly installed a software (MBS Navision) with an option for MSDE
installation checked. The result turned out to be non-functional SQL Server
2005 that cannot be reinstalled, removed or repared.
Is there a way to remove the MSDE components and repair or reinstall SQL
Server 2005 without formatting?
Thank youin advance,
HrvojeGu
"Hrvoje Vrbanc" wrote:

> Hello all!
> I write this post on behalf of my colleagues so I don't know a full pictur
e
> but this is the situation:
> On a Win 2k3 machine with a SQL Server 2005 installed, a colleague
> mistakenly installed a software (MBS Navision) with an option for MSDE
> installation checked. The result turned out to be non-functional SQL Serve
r
> 2005 that cannot be reinstalled, removed or repared.
> Is there a way to remove the MSDE components and repair or reinstall SQL
> Server 2005 without formatting?
> Thank youin advance,
> Hrvoje
>
Have you checked out http://support.microsoft.com/kb/290991 on how to remove
SQL 2000 manually.
To remove SQL 2005 manually see http://support.microsoft.com/kb/909967
although there is a command line option to reinstall (REINSTALLMODE) the
instance see http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Johnsql

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advance
Hi,
See the below link to manually remove MSDE.
http://support.microsoft.com/default...b;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advanceHi,
See the below link to manually remove MSDE.
http://support.microsoft.com/defaul...kb;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE instance restore question

how do I reinstall the MSDE instance after I restored my server?
The issue that I am having is that I can not restore the database because I
can not start the MSSQL$LDMSDATA service. So at this point I need to
reinstall the MSDE
instance.
Unless someone has a better idea.
Thanks in advanceHi,
See the below link to manually remove MSDE.
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991
After that you can do a fresh install and restore the databases.
Thanks
Hari
SQL Server MVP
"Greg" <gregkh@.hotmail.com> wrote in message
news:075D3330-8F53-41D5-9544-D45C8954B055@.microsoft.com...
> how do I reinstall the MSDE instance after I restored my server?
> The issue that I am having is that I can not restore the database because
> I
> can not start the MSSQL$LDMSDATA service. So at this point I need to
> reinstall the MSDE
> instance.
> Unless someone has a better idea.
> Thanks in advance

MSDE Installation

Hello,
I must make a setup that will Install MSDE, restore a blank database and
install my application.
I have already made it with no problem, but now I run into a very big
problem on some computers with Win 98 and NT4.
These computers don't have file sharing (on 98) or no server service working
(Win NT).
The problem is that my custommer doesn't want to check if the server
service, or if the file sharing is enabled.
So, he says that the setup doesn't work.
Can someone tell me how I can check if the server servide (NT4) is working
or if the file sharing is enabled (98) in windows Installer as I launch the
MSI for MSDE in a msi file I made?
Is it possible to install MSDE without the service Server (or file
sharing)?
Is it possible to install the server servide without the user doing anything
(For example on NT, I install a false network adaptater and the server
service)?
Thank you
Marc Allard
Allcomp
Hi Allcomp
are using merge modules or MSDE Bootstrapper Installer to embed MSDE with
setup of ur custom application. I am having a similar requirement, cud u pls
help me with this?
thanks
"Allcomp" wrote:

> Hello,
> I must make a setup that will Install MSDE, restore a blank database and
> install my application.
> I have already made it with no problem, but now I run into a very big
> problem on some computers with Win 98 and NT4.
> These computers don't have file sharing (on 98) or no server service working
> (Win NT).
> The problem is that my custommer doesn't want to check if the server
> service, or if the file sharing is enabled.
> So, he says that the setup doesn't work.
> Can someone tell me how I can check if the server servide (NT4) is working
> or if the file sharing is enabled (98) in windows Installer as I launch the
> MSI for MSDE in a msi file I made?
> Is it possible to install MSDE without the service Server (or file
> sharing)?
> Is it possible to install the server servide without the user doing anything
> (For example on NT, I install a false network adaptater and the server
> service)?
> Thank you
> Marc Allard
> Allcomp
>
>
>
|||Hi Marc,
I do not have much Idea about the Server Service, but I can answer your
Question about
"Is it possible to install MSDE without the service Server (or file
sharing)?"
Yes, MSDE is supported on Windows 98 and Windows NT Workstations.
For more details about the Software and hardware requirements of various
editions of SQL Server including MSDE, please go through the folliwing MSDN
articles
http://msdn.microsoft.com/library/de...us/instsql/in_
overview_74vn.asp
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_7eur.asp
MSDE Installation
http://msdn.microsoft.com/library/de...us/distsql/dis
tsql_3usf.asp
http://msdn.microsoft.com/library/de...us/distsql/dis
tsql_84xl.asp
Thanks
Soma Sekhara Reddy