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.
Showing posts with label upon. Show all posts
Showing posts with label upon. Show all posts
Monday, March 26, 2012
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
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
Wednesday, March 7, 2012
MSDE install runs after reboot
After installing MSDE SP3a on a windows server 2003 machine, I am prompted for a reboot. Upon rebooting, the installer still seems to be running as a dialog pops up saying something about configuring MSDE. Then the MSDE service is restarted.
This may not sound like a problem, but I am starting the MSDE installer from InstallShield and after rebooting I have no idea when MSDE is done with the database and when I can start running my db config scripts.
What is MSDE doing after reboot? Is it necessary? When do I know it's done? I'm temted to just have my script wait for a minute before running, but that's not very professional, is it?
Thanks,
hi,
"yaknuts" <yaknuts@.discussions.microsoft.com> ha scritto nel messaggio
news:BE797E25-E978-4ED8-8B15-5ABF4AD6174E@.microsoft.com...
> What is MSDE doing after reboot? Is it necessary? When do I know it's
done? I'm temted to
>just have my script wait for a minute before running, but that's not very
professional, is it?
after reboot, a lot of COM object are registred, including SQL-DMO , MDAC if
versoion required...
service are set...
some users forced not rebooting passing the REBOOT=""ReallySuppress""
WindowsInstaller parameter, but I'm not very confidentent with =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Well, I wish there was a way I could tell it to not restart the service after it has already rebooted. The Reboot isn't my main concern, but more or less after the reboot, the service I just installed with my installshield package is started, and wants t
o run the config script, however, MSDE is still being modfied and the services are restarted again WHILE mine are accessing it, causing error,
hopefully you understand my dilemma, as it's really frustrating to me and there should be a way to get around this...
Thanks,
Jacob
"Andrea Montanari" wrote:
> hi,
> "yaknuts" <yaknuts@.discussions.microsoft.com> ha scritto nel messaggio
> news:BE797E25-E978-4ED8-8B15-5ABF4AD6174E@.microsoft.com...
> done? I'm temted to
> professional, is it?
> after reboot, a lot of COM object are registred, including SQL-DMO , MDAC if
> versoion required...
> service are set...
> some users forced not rebooting passing the REBOOT=""ReallySuppress""
> WindowsInstaller parameter, but I'm not very confidentent with =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Jacob,
"Jacob Schroeder (yaknuts)" <Jacob Schroeder
(yaknuts)@.discussions.microsoft.com> ha scritto nel messaggio
news:603168F6-92B6-4F94-B6DF-F8633B78A0AA@.microsoft.com...
> Well, I wish there was a way I could tell it to not restart the service
after it has already
>rebooted. The Reboot isn't my main concern, but more or less after the
reboot, the
>service I just installed with my installshield package is started, and
wants to run the
>config script, however, MSDE is still being modfied and the services are
restarted
>again WHILE mine are accessing it, causing error,
> hopefully you understand my dilemma, as it's really frustrating to me and
there should
>be a way to get around this...
unfortunately I'm not a Wise pro =;-D
I do install MSDE as a separate package... self contained.... so I do not
care about reboot requirements...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Did you wite your own service app?
You could
- work with dependencies
- use a delay, since it's a one time thing. Either use a fixed periode, or
detect if the MSDE services you need are started
JAn
"Jacob Schroeder (yaknuts)" <Jacob Schroeder
(yaknuts)@.discussions.microsoft.com> wrote in message
news:603168F6-92B6-4F94-B6DF-F8633B78A0AA@.microsoft.com...
> Well, I wish there was a way I could tell it to not restart the service
after it has already rebooted. The Reboot isn't my main concern, but more
or less after the reboot, the service I just installed with my installshield
package is started, and wants to run the config script, however, MSDE is
still being modfied and the services are restarted again WHILE mine are
accessing it, causing error,
> hopefully you understand my dilemma, as it's really frustrating to me and
there should be a way to get around this...[vbcol=seagreen]
> Thanks,
> Jacob
>
> "Andrea Montanari" wrote:
it's[vbcol=seagreen]
very[vbcol=seagreen]
MDAC if[vbcol=seagreen]
This may not sound like a problem, but I am starting the MSDE installer from InstallShield and after rebooting I have no idea when MSDE is done with the database and when I can start running my db config scripts.
What is MSDE doing after reboot? Is it necessary? When do I know it's done? I'm temted to just have my script wait for a minute before running, but that's not very professional, is it?
Thanks,
hi,
"yaknuts" <yaknuts@.discussions.microsoft.com> ha scritto nel messaggio
news:BE797E25-E978-4ED8-8B15-5ABF4AD6174E@.microsoft.com...
> What is MSDE doing after reboot? Is it necessary? When do I know it's
done? I'm temted to
>just have my script wait for a minute before running, but that's not very
professional, is it?
after reboot, a lot of COM object are registred, including SQL-DMO , MDAC if
versoion required...
service are set...
some users forced not rebooting passing the REBOOT=""ReallySuppress""
WindowsInstaller parameter, but I'm not very confidentent with =;-D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Well, I wish there was a way I could tell it to not restart the service after it has already rebooted. The Reboot isn't my main concern, but more or less after the reboot, the service I just installed with my installshield package is started, and wants t
o run the config script, however, MSDE is still being modfied and the services are restarted again WHILE mine are accessing it, causing error,
hopefully you understand my dilemma, as it's really frustrating to me and there should be a way to get around this...
Thanks,
Jacob
"Andrea Montanari" wrote:
> hi,
> "yaknuts" <yaknuts@.discussions.microsoft.com> ha scritto nel messaggio
> news:BE797E25-E978-4ED8-8B15-5ABF4AD6174E@.microsoft.com...
> done? I'm temted to
> professional, is it?
> after reboot, a lot of COM object are registred, including SQL-DMO , MDAC if
> versoion required...
> service are set...
> some users forced not rebooting passing the REBOOT=""ReallySuppress""
> WindowsInstaller parameter, but I'm not very confidentent with =;-D
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Jacob,
"Jacob Schroeder (yaknuts)" <Jacob Schroeder
(yaknuts)@.discussions.microsoft.com> ha scritto nel messaggio
news:603168F6-92B6-4F94-B6DF-F8633B78A0AA@.microsoft.com...
> Well, I wish there was a way I could tell it to not restart the service
after it has already
>rebooted. The Reboot isn't my main concern, but more or less after the
reboot, the
>service I just installed with my installshield package is started, and
wants to run the
>config script, however, MSDE is still being modfied and the services are
restarted
>again WHILE mine are accessing it, causing error,
> hopefully you understand my dilemma, as it's really frustrating to me and
there should
>be a way to get around this...
unfortunately I'm not a Wise pro =;-D
I do install MSDE as a separate package... self contained.... so I do not
care about reboot requirements...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Did you wite your own service app?
You could
- work with dependencies
- use a delay, since it's a one time thing. Either use a fixed periode, or
detect if the MSDE services you need are started
JAn
"Jacob Schroeder (yaknuts)" <Jacob Schroeder
(yaknuts)@.discussions.microsoft.com> wrote in message
news:603168F6-92B6-4F94-B6DF-F8633B78A0AA@.microsoft.com...
> Well, I wish there was a way I could tell it to not restart the service
after it has already rebooted. The Reboot isn't my main concern, but more
or less after the reboot, the service I just installed with my installshield
package is started, and wants to run the config script, however, MSDE is
still being modfied and the services are restarted again WHILE mine are
accessing it, causing error,
> hopefully you understand my dilemma, as it's really frustrating to me and
there should be a way to get around this...[vbcol=seagreen]
> Thanks,
> Jacob
>
> "Andrea Montanari" wrote:
it's[vbcol=seagreen]
very[vbcol=seagreen]
MDAC if[vbcol=seagreen]
Subscribe to:
Posts (Atom)