hhhhelp, restore

ho fatto un update che non dovevo senza fare backup prima come posso
ripescare i dati?
gia committato ovviamente
carlo
Usted habla ingls?
(Also, pick a single newsgroup to post to.)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Carlo wrote:

>ho fatto un update che non dovevo senza fare backup prima come posso
>ripescare i dati?
>gia committato ovviamente
>carlo
>
>
|||Translated by bablefish:
I have made update that I did not have without to make before backup as I can find again the data?
Probably not, if you don't have any backups at all. Do you have transaction log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx.gbl...
> ho fatto un update che non dovevo senza fare backup prima come posso ripescare i dati?
> gia committato ovviamente
> carlo
>
|||Thank you all for Translation.
Carlo,
All on to tibor,
You can see the database before update Provided you have the below :-
1. Datbase must be in FULL recovery mode
2. Full database backup
3. All transaction log backups
If you passed the above then you can do a Point in time recovery until you
update the data:-
1. Perform a Transaction log backup in your database.
2. Create a new database
3. Restore the full database backup WITH NORECOVERY option into the new
database
4. Restore the subsequent transaction log backups till the last (DO not
restore last) with NORECOVERY option
5. Restore the Last Transaction log backup with Recovery option and STOPAT
='Date and time"
Refer RESTORE database/Log in books online for more information
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Translated by bablefish:
> I have made update that I did not have without to make before backup as I
> can find again the data?
> Probably not, if you don't have any backups at all. Do you have
> transaction log backups?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message
> news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
|||Out of curiosity, would this restore up to the last complete transaction up
to the point in time specified but leave any transactions that bridge the
time un-applied (I would hope so)? And I would think maybe a log reader
would be helpful to pinpoint the EXACT time. Just plugging in a time because
it was "about 8:15 when it happened" doesn't seem like a great idea.
Bob Castleman
DBA Poseur.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Thank you all for Translation.
> Carlo,
> All on to tibor,
> You can see the database before update Provided you have the below :-
> 1. Datbase must be in FULL recovery mode
> 2. Full database backup
> 3. All transaction log backups
> If you passed the above then you can do a Point in time recovery until you
> update the data:-
> 1. Perform a Transaction log backup in your database.
> 2. Create a new database
> 3. Restore the full database backup WITH NORECOVERY option into the new
> database
> 4. Restore the subsequent transaction log backups till the last (DO not
> restore last) with NORECOVERY option
> 5. Restore the Last Transaction log backup with Recovery option and STOPAT
> ='Date and time"
> Refer RESTORE database/Log in books online for more information
> Thanks
> Hari
> SQL Server MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
>
|||Yes, uncommitted transactions will be rolled back. And, yes a log mining tool is good to have to
pinpoint the time. An option is to restore the same last log backup several times with standby and
STOPAT pushing the time forward a little bit each time:
http://www.karaszi.com/SQLServer/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Bob Castleman" <nomail@.here> wrote in message news:%23MAq5ErcFHA.720@.TK2MSFTNGP15.phx.gbl...
> Out of curiosity, would this restore up to the last complete transaction up to the point in time
> specified but leave any transactions that bridge the time un-applied (I would hope so)? And I
> would think maybe a log reader would be helpful to pinpoint the EXACT time. Just plugging in a
> time because it was "about 8:15 when it happened" doesn't seem like a great idea.
> Bob Castleman
> DBA Poseur.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
>

hhhhelp, restore

ho fatto un update che non dovevo senza fare backup prima come posso
ripescare i dati?
gia committato ovviamente
carlo
Usted habla ingls?
(Also, pick a single newsgroup to post to.)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Carlo wrote:

>ho fatto un update che non dovevo senza fare backup prima come posso
>ripescare i dati?
>gia committato ovviamente
>carlo
>
>
|||Translated by bablefish:
I have made update that I did not have without to make before backup as I can find again the data?
Probably not, if you don't have any backups at all. Do you have transaction log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx.gbl...
> ho fatto un update che non dovevo senza fare backup prima come posso ripescare i dati?
> gia committato ovviamente
> carlo
>
|||Mike, I believe he's Italian (I recognize the writing since I'm Italian too).
I think he's saying he updated some data without backing up his database first.
Now he thinks he messed up and wants to uncommit those changes.
Carlo, non e eventuale senza backup.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:ey%23DQPncFHA.4040@.TK2MSFTNGP14.phx.gbl...
Usted habla ingls?
(Also, pick a single newsgroup to post to.)
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Carlo wrote:
ho fatto un update che non dovevo senza fare backup prima come posso
ripescare i dati?
gia committato ovviamente
carlo
|||Thank you all for Translation.
Carlo,
All on to tibor,
You can see the database before update Provided you have the below :-
1. Datbase must be in FULL recovery mode
2. Full database backup
3. All transaction log backups
If you passed the above then you can do a Point in time recovery until you
update the data:-
1. Perform a Transaction log backup in your database.
2. Create a new database
3. Restore the full database backup WITH NORECOVERY option into the new
database
4. Restore the subsequent transaction log backups till the last (DO not
restore last) with NORECOVERY option
5. Restore the Last Transaction log backup with Recovery option and STOPAT
='Date and time"
Refer RESTORE database/Log in books online for more information
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Translated by bablefish:
> I have made update that I did not have without to make before backup as I
> can find again the data?
> Probably not, if you don't have any backups at all. Do you have
> transaction log backups?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message
> news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
|||Out of curiosity, would this restore up to the last complete transaction up
to the point in time specified but leave any transactions that bridge the
time un-applied (I would hope so)? And I would think maybe a log reader
would be helpful to pinpoint the EXACT time. Just plugging in a time because
it was "about 8:15 when it happened" doesn't seem like a great idea.
Bob Castleman
DBA Poseur.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Thank you all for Translation.
> Carlo,
> All on to tibor,
> You can see the database before update Provided you have the below :-
> 1. Datbase must be in FULL recovery mode
> 2. Full database backup
> 3. All transaction log backups
> If you passed the above then you can do a Point in time recovery until you
> update the data:-
> 1. Perform a Transaction log backup in your database.
> 2. Create a new database
> 3. Restore the full database backup WITH NORECOVERY option into the new
> database
> 4. Restore the subsequent transaction log backups till the last (DO not
> restore last) with NORECOVERY option
> 5. Restore the Last Transaction log backup with Recovery option and STOPAT
> ='Date and time"
> Refer RESTORE database/Log in books online for more information
> Thanks
> Hari
> SQL Server MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
>
|||Yes, uncommitted transactions will be rolled back. And, yes a log mining tool is good to have to
pinpoint the time. An option is to restore the same last log backup several times with standby and
STOPAT pushing the time forward a little bit each time:
http://www.karaszi.com/SQLServer/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Bob Castleman" <nomail@.here> wrote in message news:%23MAq5ErcFHA.720@.TK2MSFTNGP15.phx.gbl...
> Out of curiosity, would this restore up to the last complete transaction up to the point in time
> specified but leave any transactions that bridge the time un-applied (I would hope so)? And I
> would think maybe a log reader would be helpful to pinpoint the EXACT time. Just plugging in a
> time because it was "about 8:15 when it happened" doesn't seem like a great idea.
> Bob Castleman
> DBA Poseur.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
>

hhhhelp, restore

ho fatto un update che non dovevo senza fare backup prima come posso
ripescare i dati?
gia committato ovviamente
carloUsted habla ingls?
(Also, pick a single newsgroup to post to.)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Carlo wrote:

>ho fatto un update che non dovevo senza fare backup prima come posso
>ripescare i dati?
>gia committato ovviamente
>carlo
>
>|||Translated by bablefish:
I have made update that I did not have without to make before backup as I ca
n find again the data?
Probably not, if you don't have any backups at all. Do you have transaction
log backups?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx
.gbl...
> ho fatto un update che non dovevo senza fare backup prima come posso ripes
care i dati?
> gia committato ovviamente
> carlo
>|||Mike, I believe he's Italian (I recognize the writing since I'm Italian too)
.
I think he's saying he updated some data without backing up his database fir
st.
Now he thinks he messed up and wants to uncommit those changes.
Carlo, non e eventuale senza backup.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:ey%
23DQPncFHA.4040@.TK2MSFTNGP14.phx.gbl...
Usted habla ingls?
(Also, pick a single newsgroup to post to.)
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Carlo wrote:
ho fatto un update che non dovevo senza fare backup prima come posso
ripescare i dati?
gia committato ovviamente
carlo|||Thank you all for Translation.
Carlo,
All on to tibor,
You can see the database before update Provided you have the below :-
1. Datbase must be in FULL recovery mode
2. Full database backup
3. All transaction log backups
If you passed the above then you can do a Point in time recovery until you
update the data:-
1. Perform a Transaction log backup in your database.
2. Create a new database
3. Restore the full database backup WITH NORECOVERY option into the new
database
4. Restore the subsequent transaction log backups till the last (DO not
restore last) with NORECOVERY option
5. Restore the Last Transaction log backup with Recovery option and STOPAT
='Date and time"
Refer RESTORE database/Log in books online for more information
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
> Translated by bablefish:
> I have made update that I did not have without to make before backup as I
> can find again the data?
> Probably not, if you don't have any backups at all. Do you have
> transaction log backups?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Carlo" <carletto.mNOSPAM@.gmail.com> wrote in message
> news:OnD6BLncFHA.2664@.TK2MSFTNGP15.phx.gbl...
>|||Out of curiosity, would this restore up to the last complete transaction up
to the point in time specified but leave any transactions that bridge the
time un-applied (I would hope so)? And I would think maybe a log reader
would be helpful to pinpoint the EXACT time. Just plugging in a time because
it was "about 8:15 when it happened" doesn't seem like a great idea.
Bob Castleman
DBA Poseur.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Thank you all for Translation.
> Carlo,
> All on to tibor,
> You can see the database before update Provided you have the below :-
> 1. Datbase must be in FULL recovery mode
> 2. Full database backup
> 3. All transaction log backups
> If you passed the above then you can do a Point in time recovery until you
> update the data:-
> 1. Perform a Transaction log backup in your database.
> 2. Create a new database
> 3. Restore the full database backup WITH NORECOVERY option into the new
> database
> 4. Restore the subsequent transaction log backups till the last (DO not
> restore last) with NORECOVERY option
> 5. Restore the Last Transaction log backup with Recovery option and STOPAT
> ='Date and time"
> Refer RESTORE database/Log in books online for more information
> Thanks
> Hari
> SQL Server MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:esihFlncFHA.2180@.TK2MSFTNGP12.phx.gbl...
>|||Yes, uncommitted transactions will be rolled back. And, yes a log mining too
l is good to have to
pinpoint the time. An option is to restore the same last log backup several
times with standby and
STOPAT pushing the time forward a little bit each time:
http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Bob Castleman" <nomail@.here> wrote in message news:%23MAq5ErcFHA.720@.TK2MSFTNGP15.phx.gbl..
.
> Out of curiosity, would this restore up to the last complete transaction u
p to the point in time
> specified but leave any transactions that bridge the time un-applied (I wo
uld hope so)? And I
> would think maybe a log reader would be helpful to pinpoint the EXACT time
. Just plugging in a
> time because it was "about 8:15 when it happened" doesn't seem like a grea
t idea.
> Bob Castleman
> DBA Poseur.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OY95kSqcFHA.3504@.TK2MSFTNGP12.phx.gbl...
>

HELP: SQL Server 2000 will not start after full system restore

Hi,
I just did a full system backup, memory and hard disk reconfiguration,
and a full system restore of my SQL Server 2000 machine.
SQL Server refuses to start as a service giving the error message:
"could not start the MSSQLSERVER service on the local computer"
"Error 3: the system cannot find the path specified"
It however starts from the command prompt by simply executing:
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
Any assistance welcome!Hi
Check what flags you have specified when you start it as a service.
John
"kim@.kasnet.com" wrote:

> Hi,
> I just did a full system backup, memory and hard disk reconfiguration,
> and a full system restore of my SQL Server 2000 machine.
> SQL Server refuses to start as a service giving the error message:
> "could not start the MSSQLSERVER service on the local computer"
> "Error 3: the system cannot find the path specified"
> It however starts from the command prompt by simply executing:
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> Any assistance welcome!
>|||Hi John,
There are no flags specified as startup parameters... is there
anything else I should check?
Kim
On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
[vbcol=seagreen]
>Hi
>Check what flags you have specified when you start it as a service.
>John
>"kim@.kasnet.com" wrote:
>|||Hi
Check the registry
key& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\MSSQLServer\Parame
ters]
You will find entries like:
"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.md
f"
"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
Server\\MSSQL\\data\\mastlog.ldf"
Check that these files/directories exists. Other possible parameters are
detailed in Books Online topic "sqlservr Application"
John
"velliott@.hdhopwood.com" wrote:

> Hi John,
> There are no flags specified as startup parameters... is there
> anything else I should check?
> Kim
> On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
> <jbellnewsposts@.hotmail.com> wrote:
>
>|||I checked the registry entries and the only difference is that there
are single backslashes in the directory path. All other path entries
in the registry are represented the same way.
If this is the problem, my logic tells me that the SQL Server should
not start from the command prompt anyway!
Is there a way to get the service startup process to indicate which
specific path it cannot find?
Kim
On Thu, 27 Apr 2006 00:04:01 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
[vbcol=seagreen]
>Hi
>Check the registry
>key& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\MSSQLServer\Param
eters]
>You will find entries like:
>"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.m
df"
>"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
>"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
>Server\\MSSQL\\data\\mastlog.ldf"
>Check that these files/directories exists. Other possible parameters are
>detailed in Books Online topic "sqlservr Application"
>John
>
>"velliott@.hdhopwood.com" wrote:
>|||Hi
The double backslashes are from an export of the registry check other
registry values such as
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\Setup]
John
"velliott@.hdhopwood.com" wrote:

> I checked the registry entries and the only difference is that there
> are single backslashes in the directory path. All other path entries
> in the registry are represented the same way.
> If this is the problem, my logic tells me that the SQL Server should
> not start from the command prompt anyway!
> Is there a way to get the service startup process to indicate which
> specific path it cannot find?
> Kim
> On Thu, 27 Apr 2006 00:04:01 -0700, John Bell
> <jbellnewsposts@.hotmail.com> wrote:
>
>|||John,
The registry keys in error were:
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLServer\ImageP
ath]
and
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLServer\Perfor
mance\Library]
Both contained the DOS version of the path (eg.
C:\Program~1\Micro~2\...) to the relevant binaries.
I expanded the paths and the service started without error!
Many thanks for your patience and invaluable assistance!!!
Kim
On Thu, 27 Apr 2006 09:50:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
[vbcol=seagreen]
>Hi
>The double backslashes are from an export of the registry check other
>registry values such as
>& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\Setup]
>John
>"velliott@.hdhopwood.com" wrote:
>

HELP: SQL Server 2000 will not start after full system restore

Hi,
I just did a full system backup, memory and hard disk reconfiguration,
and a full system restore of my SQL Server 2000 machine.
SQL Server refuses to start as a service giving the error message:
"could not start the MSSQLSERVER service on the local computer"
"Error 3: the system cannot find the path specified"
It however starts from the command prompt by simply executing:
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
Any assistance welcome!Hi
Check what flags you have specified when you start it as a service.
John
"kim@.kasnet.com" wrote:
> Hi,
> I just did a full system backup, memory and hard disk reconfiguration,
> and a full system restore of my SQL Server 2000 machine.
> SQL Server refuses to start as a service giving the error message:
> "could not start the MSSQLSERVER service on the local computer"
> "Error 3: the system cannot find the path specified"
> It however starts from the command prompt by simply executing:
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> Any assistance welcome!
>|||Hi John,
There are no flags specified as startup parameters... is there
anything else I should check?
Kim
On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>Check what flags you have specified when you start it as a service.
>John
>"kim@.kasnet.com" wrote:
>> Hi,
>> I just did a full system backup, memory and hard disk reconfiguration,
>> and a full system restore of my SQL Server 2000 machine.
>> SQL Server refuses to start as a service giving the error message:
>> "could not start the MSSQLSERVER service on the local computer"
>> "Error 3: the system cannot find the path specified"
>> It however starts from the command prompt by simply executing:
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
>> Any assistance welcome!|||Hi
Check the registry
key[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
You will find entries like:
"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.mdf"
"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
Server\\MSSQL\\data\\mastlog.ldf"
Check that these files/directories exists. Other possible parameters are
detailed in Books Online topic "sqlservr Application"
John
"velliott@.hdhopwood.com" wrote:
> Hi John,
> There are no flags specified as startup parameters... is there
> anything else I should check?
> Kim
> On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
> <jbellnewsposts@.hotmail.com> wrote:
> >Hi
> >
> >Check what flags you have specified when you start it as a service.
> >
> >John
> >
> >"kim@.kasnet.com" wrote:
> >
> >> Hi,
> >>
> >> I just did a full system backup, memory and hard disk reconfiguration,
> >> and a full system restore of my SQL Server 2000 machine.
> >>
> >> SQL Server refuses to start as a service giving the error message:
> >>
> >> "could not start the MSSQLSERVER service on the local computer"
> >> "Error 3: the system cannot find the path specified"
> >>
> >> It however starts from the command prompt by simply executing:
> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> >>
> >> Any assistance welcome!
> >>
>|||I checked the registry entries and the only difference is that there
are single backslashes in the directory path. All other path entries
in the registry are represented the same way.
If this is the problem, my logic tells me that the SQL Server should
not start from the command prompt anyway!
Is there a way to get the service startup process to indicate which
specific path it cannot find?
Kim
On Thu, 27 Apr 2006 00:04:01 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>Check the registry
>key[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
>You will find entries like:
>"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.mdf"
>"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
>"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
>Server\\MSSQL\\data\\mastlog.ldf"
>Check that these files/directories exists. Other possible parameters are
>detailed in Books Online topic "sqlservr Application"
>John
>
>"velliott@.hdhopwood.com" wrote:
>> Hi John,
>> There are no flags specified as startup parameters... is there
>> anything else I should check?
>> Kim
>> On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
>> <jbellnewsposts@.hotmail.com> wrote:
>> >Hi
>> >
>> >Check what flags you have specified when you start it as a service.
>> >
>> >John
>> >
>> >"kim@.kasnet.com" wrote:
>> >
>> >> Hi,
>> >>
>> >> I just did a full system backup, memory and hard disk reconfiguration,
>> >> and a full system restore of my SQL Server 2000 machine.
>> >>
>> >> SQL Server refuses to start as a service giving the error message:
>> >>
>> >> "could not start the MSSQLSERVER service on the local computer"
>> >> "Error 3: the system cannot find the path specified"
>> >>
>> >> It however starts from the command prompt by simply executing:
>> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
>> >>
>> >> Any assistance welcome!
>> >>
>>|||Hi
The double backslashes are from an export of the registry check other
registry values such as
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup]
John
"velliott@.hdhopwood.com" wrote:
> I checked the registry entries and the only difference is that there
> are single backslashes in the directory path. All other path entries
> in the registry are represented the same way.
> If this is the problem, my logic tells me that the SQL Server should
> not start from the command prompt anyway!
> Is there a way to get the service startup process to indicate which
> specific path it cannot find?
> Kim
> On Thu, 27 Apr 2006 00:04:01 -0700, John Bell
> <jbellnewsposts@.hotmail.com> wrote:
> >Hi
> >
> >Check the registry
> >key[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
> >
> >You will find entries like:
> >"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.mdf"
> >"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
> >"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
> >Server\\MSSQL\\data\\mastlog.ldf"
> >
> >Check that these files/directories exists. Other possible parameters are
> >detailed in Books Online topic "sqlservr Application"
> >
> >John
> >
> >
> >"velliott@.hdhopwood.com" wrote:
> >
> >> Hi John,
> >>
> >> There are no flags specified as startup parameters... is there
> >> anything else I should check?
> >>
> >> Kim
> >>
> >> On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
> >> <jbellnewsposts@.hotmail.com> wrote:
> >>
> >> >Hi
> >> >
> >> >Check what flags you have specified when you start it as a service.
> >> >
> >> >John
> >> >
> >> >"kim@.kasnet.com" wrote:
> >> >
> >> >> Hi,
> >> >>
> >> >> I just did a full system backup, memory and hard disk reconfiguration,
> >> >> and a full system restore of my SQL Server 2000 machine.
> >> >>
> >> >> SQL Server refuses to start as a service giving the error message:
> >> >>
> >> >> "could not start the MSSQLSERVER service on the local computer"
> >> >> "Error 3: the system cannot find the path specified"
> >> >>
> >> >> It however starts from the command prompt by simply executing:
> >> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> >> >>
> >> >> Any assistance welcome!
> >> >>
> >>
> >>
>|||John,
The registry keys in error were:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\ImagePath]
and
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\Performance\Library]
Both contained the DOS version of the path (eg.
C:\Program~1\Micro~2\...) to the relevant binaries.
I expanded the paths and the service started without error!
Many thanks for your patience and invaluable assistance!!!
Kim
On Thu, 27 Apr 2006 09:50:02 -0700, John Bell
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>The double backslashes are from an export of the registry check other
>registry values such as
>[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup]
>John
>"velliott@.hdhopwood.com" wrote:
>> I checked the registry entries and the only difference is that there
>> are single backslashes in the directory path. All other path entries
>> in the registry are represented the same way.
>> If this is the problem, my logic tells me that the SQL Server should
>> not start from the command prompt anyway!
>> Is there a way to get the service startup process to indicate which
>> specific path it cannot find?
>> Kim
>> On Thu, 27 Apr 2006 00:04:01 -0700, John Bell
>> <jbellnewsposts@.hotmail.com> wrote:
>> >Hi
>> >
>> >Check the registry
>> >key[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters]
>> >
>> >You will find entries like:
>> >"SQLArg0"="-dC:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\master.mdf"
>> >"SQLArg1"="-eC:\\Program Files\\Microsoft SQL Server\\MSSQL\\log\\ERRORLOG"
>> >"SQLArg2"="-lC:\\Program Files\\Microsoft SQL
>> >Server\\MSSQL\\data\\mastlog.ldf"
>> >
>> >Check that these files/directories exists. Other possible parameters are
>> >detailed in Books Online topic "sqlservr Application"
>> >
>> >John
>> >
>> >
>> >"velliott@.hdhopwood.com" wrote:
>> >
>> >> Hi John,
>> >>
>> >> There are no flags specified as startup parameters... is there
>> >> anything else I should check?
>> >>
>> >> Kim
>> >>
>> >> On Tue, 25 Apr 2006 09:48:01 -0700, John Bell
>> >> <jbellnewsposts@.hotmail.com> wrote:
>> >>
>> >> >Hi
>> >> >
>> >> >Check what flags you have specified when you start it as a service.
>> >> >
>> >> >John
>> >> >
>> >> >"kim@.kasnet.com" wrote:
>> >> >
>> >> >> Hi,
>> >> >>
>> >> >> I just did a full system backup, memory and hard disk reconfiguration,
>> >> >> and a full system restore of my SQL Server 2000 machine.
>> >> >>
>> >> >> SQL Server refuses to start as a service giving the error message:
>> >> >>
>> >> >> "could not start the MSSQLSERVER service on the local computer"
>> >> >> "Error 3: the system cannot find the path specified"
>> >> >>
>> >> >> It however starts from the command prompt by simply executing:
>> >> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
>> >> >>
>> >> >> Any assistance welcome!
>> >> >>
>> >>
>> >>
>>|||<kim@.kasnet.com> wrote in message
news:l0fs421805aj0doegq6e26ft224ll3mj99@.4ax.com...
> Hi,
> I just did a full system backup, memory and hard disk reconfiguration,
> and a full system restore of my SQL Server 2000 machine.
> SQL Server refuses to start as a service giving the error message:
> "could not start the MSSQLSERVER service on the local computer"
> "Error 3: the system cannot find the path specified"
> It however starts from the command prompt by simply executing:
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> Any assistance welcome!
How did you do your system restore?
We had a situation once where files were robocopied from old hardware to
new. The problem with that was that some files took longer to copy than
others, and this messed up the 8.3 names of those blasted c:\Program
Files\Microsoft ... directories. For example, the SQL Server directory was
MICROS~4 on the old box, but MICROS~2 on the new box. We didn't notice this
until we started getting weird errors like you describe. When we checked
the registry, we found that many keys referenced those directories by 8.3
name. Fixing it was a headache.|||Hi Karen
The OP has found that the registry enties
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\ImagePath]
and
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\Performance\Library]
had 8.3 files names in them, change them to the correct values solved her
problem.
John
"Karen Collins" wrote:
> <kim@.kasnet.com> wrote in message
> news:l0fs421805aj0doegq6e26ft224ll3mj99@.4ax.com...
> > Hi,
> >
> > I just did a full system backup, memory and hard disk reconfiguration,
> > and a full system restore of my SQL Server 2000 machine.
> >
> > SQL Server refuses to start as a service giving the error message:
> >
> > "could not start the MSSQLSERVER service on the local computer"
> > "Error 3: the system cannot find the path specified"
> >
> > It however starts from the command prompt by simply executing:
> > "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe"
> >
> > Any assistance welcome!
> How did you do your system restore?
> We had a situation once where files were robocopied from old hardware to
> new. The problem with that was that some files took longer to copy than
> others, and this messed up the 8.3 names of those blasted c:\Program
> Files\Microsoft ... directories. For example, the SQL Server directory was
> MICROS~4 on the old box, but MICROS~2 on the new box. We didn't notice this
> until we started getting weird errors like you describe. When we checked
> the registry, we found that many keys referenced those directories by 8.3
> name. Fixing it was a headache.
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:86E6F2AF-BD89-46C2-88BB-1329784382E3@.microsoft.com...
> Hi Karen
> The OP has found that the registry enties
> [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\ImagePath]
> and
> [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer\Performance\Library]
> had 8.3 files names in them, change them to the correct values solved her
> problem.
Thanks for the update. Glad to hear she was able to fix the problem.

HELP: Point in time restore : HOW ?

I have full backup of database at 13:00
and another full backup at 17:00.
I've made backup of transaction log at 17:05
When I try to restore database to state at
15:10 (point in time) , the dialogue in Enterprise Manager
says that only time after 17:05 is valid.
It seems to me that I've done something wrong at 17:05 while taking
trans. log backup.
But, again, if I have full backups at 13:00 and 17:00 restoring
database to point in time at 15:10 should be possible ?!
Any help is appreciated.
Pagus
Hi Pagus,
Point in time recovery can be done with tlogs.... had you taken tlogs after
15:00 full backup?
Thanks
GYK
"Pagus" wrote:

> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>
|||To summarize what u currently have :
[1] First Full Database Backup @. 13:00
[2] Second Full Database Backup @. 17:00
[3] TLog @. 17:05
Trying to Point-In-Time restore to 15:10
Considering that the Point-In-Time restore is before the second DB backup,
the Second DB backup is irrelevent.
There are a few things that u shud check
[1] Was the DB in valid state when you issued the Backup @. 13:00
[2] Check the duration (Period) for the TLog backup. It should have an
end time of 17:05 and start time of what ?
Thanks,
Gopi
"Pagus" wrote:

> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>
|||Pagus <pagus@.writeme.com> wrote in message news:<5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com>. ..
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
Always used transaction logs to do a point in time restore.
Vincento
|||Hi there,
a point in time restore is only possible when using a transaction log
to do the restore. I know it probably doesnt help you but for future
reference here is the way to do it.
first restore the full backup leaving the database in no-recovery mode
then restore the transaction log backup to the point in time that you
want, this time recoverying the database after the restore completes.
Depending upon the size of your database it might be worth looking at
doing a full backup just once per day and several transaction log
backups throughout the day every hour, or couple of hours.

HELP: Point in time restore : HOW ?

I have full backup of database at 13:00
and another full backup at 17:00.

I've made backup of transaction log at 17:05

When I try to restore database to state at
15:10 (point in time) , the dialogue in Enterprise Manager
says that only time after 17:05 is valid.

It seems to me that I've done something wrong at 17:05 while taking
trans. log backup.

But, again, if I have full backups at 13:00 and 17:00 restoring
database to point in time at 15:10 should be possible ?!

Any help is appreciated.

PagusRestore the full backup from 13:00 with NORECOVERY
Restore the tLog backup to 15:10 with Recovery

Should work.

Rick

"Pagus" <pagus@.writeme.com> wrote in message
news:5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com...
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus|||"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:OzkXPNitEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Restore the full backup from 13:00 with NORECOVERY
> Restore the tLog backup to 15:10 with Recovery

I have not done this, but you may want to restore tlog backup to 15:10 with
a standby file.

I THINK you can then restore in time past 15:10 again w/o having to do the
full restore.

(hmm, I should try this now that I think about... too tired right now
though. :-)

> Should work.
>
> Rick|||> (hmm, I should try this now that I think about... too tired right now
> though. :-)

No need to Greg. I have a demo script just for this. You can restore the same tlog several times,
going forward in time, using STANDBY. I also checked with MS and this is a tested and supported
method. Here are my comments on the topic:
http://www.karaszi.com/SQLServer/in...veral_times.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:Mbndd.312510$bp1.26137@.twister.nyroc.rr.com.. .
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:OzkXPNitEHA.3200@.TK2MSFTNGP09.phx.gbl...
>> Restore the full backup from 13:00 with NORECOVERY
>> Restore the tLog backup to 15:10 with Recovery
> I have not done this, but you may want to restore tlog backup to 15:10 with
> a standby file.
> I THINK you can then restore in time past 15:10 again w/o having to do the
> full restore.
> (hmm, I should try this now that I think about... too tired right now
> though. :-)
>
>>
>> Should work.
>>
>>
>> Rick
>>
>>|||Pagus <pagus@.writeme.com> wrote in message news:<5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com>...
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus

Always used transaction logs to do a point in time restore.

Vincento|||Hi there,

a point in time restore is only possible when using a transaction log
to do the restore. I know it probably doesnt help you but for future
reference here is the way to do it.

first restore the full backup leaving the database in no-recovery mode
then restore the transaction log backup to the point in time that you
want, this time recoverying the database after the restore completes.

Depending upon the size of your database it might be worth looking at
doing a full backup just once per day and several transaction log
backups throughout the day every hour, or couple of hours.

HELP: Point in time restore : HOW ?

I have full backup of database at 13:00
and another full backup at 17:00.
I've made backup of transaction log at 17:05
When I try to restore database to state at
15:10 (point in time) , the dialogue in Enterprise Manager
says that only time after 17:05 is valid.
It seems to me that I've done something wrong at 17:05 while taking
trans. log backup.
But, again, if I have full backups at 13:00 and 17:00 restoring
database to point in time at 15:10 should be possible ?!
Any help is appreciated.
PagusRestore the full backup from 13:00 with NORECOVERY
Restore the tLog backup to 15:10 with Recovery
Should work.
Rick
"Pagus" <pagus@.writeme.com> wrote in message
news:5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com...
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>|||Hi Pagus,
Point in time recovery can be done with tlogs.... had you taken tlogs after
15:00 full backup?
Thanks
GYK
"Pagus" wrote:
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>|||"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:OzkXPNitEHA.3200@.TK2MSFTNGP09.phx.gbl...
> Restore the full backup from 13:00 with NORECOVERY
> Restore the tLog backup to 15:10 with Recovery
I have not done this, but you may want to restore tlog backup to 15:10 with
a standby file.
I THINK you can then restore in time past 15:10 again w/o having to do the
full restore.
(hmm, I should try this now that I think about... too tired right now
though. :-)
> Should work.
>
> Rick
>|||To summarize what u currently have :
[1] First Full Database Backup @. 13:00
[2] Second Full Database Backup @. 17:00
[3] TLog @. 17:05
Trying to Point-In-Time restore to 15:10
Considering that the Point-In-Time restore is before the second DB backup,
the Second DB backup is irrelevent.
There are a few things that u shud check
[1] Was the DB in valid state when you issued the Backup @. 13:00
[2] Check the duration (Period) for the TLog backup. It should have an
end time of 17:05 and start time of what ?
Thanks,
Gopi
"Pagus" wrote:
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>|||> (hmm, I should try this now that I think about... too tired right now
> though. :-)
No need to Greg. I have a demo script just for this. You can restore the same tlog several times,
going forward in time, using STANDBY. I also checked with MS and this is a tested and supported
method. Here are my comments on the topic:
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:Mbndd.312510$bp1.26137@.twister.nyroc.rr.com...
> "Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
> news:OzkXPNitEHA.3200@.TK2MSFTNGP09.phx.gbl...
>> Restore the full backup from 13:00 with NORECOVERY
>> Restore the tLog backup to 15:10 with Recovery
> I have not done this, but you may want to restore tlog backup to 15:10 with
> a standby file.
> I THINK you can then restore in time past 15:10 again w/o having to do the
> full restore.
> (hmm, I should try this now that I think about... too tired right now
> though. :-)
>
>> Should work.
>>
>> Rick
>>
>|||Pagus <pagus@.writeme.com> wrote in message news:<5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com>...
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
Always used transaction logs to do a point in time restore.
Vincento|||Hi there,
a point in time restore is only possible when using a transaction log
to do the restore. I know it probably doesnt help you but for future
reference here is the way to do it.
first restore the full backup leaving the database in no-recovery mode
then restore the transaction log backup to the point in time that you
want, this time recoverying the database after the restore completes.
Depending upon the size of your database it might be worth looking at
doing a full backup just once per day and several transaction log
backups throughout the day every hour, or couple of hours.

HELP: Point in time restore : HOW ?

I have full backup of database at 13:00
and another full backup at 17:00.
I've made backup of transaction log at 17:05
When I try to restore database to state at
15:10 (point in time) , the dialogue in Enterprise Manager
says that only time after 17:05 is valid.
It seems to me that I've done something wrong at 17:05 while taking
trans. log backup.
But, again, if I have full backups at 13:00 and 17:00 restoring
database to point in time at 15:10 should be possible ?!
Any help is appreciated.
PagusHi Pagus,
Point in time recovery can be done with tlogs.... had you taken tlogs after
15:00 full backup?
Thanks
GYK
"Pagus" wrote:

> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>|||To summarize what u currently have :
[1] First Full Database Backup @. 13:00
[2] Second Full Database Backup @. 17:00
[3] TLog @. 17:05
Trying to Point-In-Time restore to 15:10
Considering that the Point-In-Time restore is before the second DB backup,
the Second DB backup is irrelevent.
There are a few things that u shud check
[1] Was the DB in valid state when you issued the Backup @. 13:00
[2] Check the duration (Period) for the TLog backup. It should have an
end time of 17:05 and start time of what ?
Thanks,
Gopi
"Pagus" wrote:

> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
>|||Pagus <pagus@.writeme.com> wrote in message news:<5q0bn0ttoavi4q60tgfqvp4ruqa0hnopmp@.4ax.com>
..
> I have full backup of database at 13:00
> and another full backup at 17:00.
> I've made backup of transaction log at 17:05
> When I try to restore database to state at
> 15:10 (point in time) , the dialogue in Enterprise Manager
> says that only time after 17:05 is valid.
> It seems to me that I've done something wrong at 17:05 while taking
> trans. log backup.
> But, again, if I have full backups at 13:00 and 17:00 restoring
> database to point in time at 15:10 should be possible ?!
> Any help is appreciated.
> Pagus
Always used transaction logs to do a point in time restore.
Vincento|||Hi there,
a point in time restore is only possible when using a transaction log
to do the restore. I know it probably doesnt help you but for future
reference here is the way to do it.
first restore the full backup leaving the database in no-recovery mode
then restore the transaction log backup to the point in time that you
want, this time recoverying the database after the restore completes.
Depending upon the size of your database it might be worth looking at
doing a full backup just once per day and several transaction log
backups throughout the day every hour, or couple of hours.

HELP: Point in time restore

Pagus,
you options are:
(a) Restore full backup 1: 13:00
(b) Restore full backup 2: 17:00
(c) Restore full backup 2 and log 1 17:05
(d) Restore full backup 2 and do a point-in-time restore
of the log to any time between 17:00 and 17:05
To restore to 15:10, you'd need to have backed up a log
between the 2 database backups. Point-in-time is only
possible as part of the log restore, which has a concept
of transactions performed at specific times, while a
database backup only knows when the backup was created.
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
Yup, full backup at 17:00 was mistake !
Many thanks Paul,
Pagus
On Wed, 20 Oct 2004 01:52:13 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:

>Pagus,
>you options are:
>(a) Restore full backup 1: 13:00
>(b) Restore full backup 2: 17:00
>(c) Restore full backup 2 and log 1 17:05
>(d) Restore full backup 2 and do a point-in-time restore
>of the log to any time between 17:00 and 17:05
>To restore to 15:10, you'd need to have backed up a log
>between the 2 database backups. Point-in-time is only
>possible as part of the log restore, which has a concept
>of transactions performed at specific times, while a
>database backup only knows when the backup was created.
>HTH,
>Paul Ibison (SQL Server MVP)
>
>

Help: Can I restore a database only using the data file

Hi All,
Recenty, I met with a serious problem. For some unknown reason, the
log file of one of our database is missing, only the data file left.
Can I just use the data file of the database to restore the database?
Thanks.
Dobby
Ps: I use SQL Server 2000Try sp_attach_single_file_db. More information in BOL.
Dmitrij
"Dobby Cai" wrote:
> Hi All,
> Recenty, I met with a serious problem. For some unknown reason, the
> log file of one of our database is missing, only the data file left.
> Can I just use the data file of the database to restore the database?
> Thanks.
> Dobby
> Ps: I use SQL Server 2000
>|||Hi Dobby
Can you connect to the database? If so you can use sp_helpfile to see where
the log is.
If the database is not attached, then if this was SQL 2005 you could use
"FOR ATTACH_REBUILD_LOG" option of CREATE DATABASE but this is SQL 2000!
For SQL 2000 and SQL 2005 you can also use sp_attach_single_file_db
John
"Dobby Cai" wrote:
> Hi All,
> Recenty, I met with a serious problem. For some unknown reason, the
> log file of one of our database is missing, only the data file left.
> Can I just use the data file of the database to restore the database?
> Thanks.
> Dobby
> Ps: I use SQL Server 2000
>|||On Oct 4, 2:33 pm, Dmitrij Siemieniako
<DmitrijSiemieni...@.discussions.microsoft.com> wrote:
> Try sp_attach_single_file_db. More information in BOL.
> Dmitrij
> "Dobby Cai" wrote:
> > Hi All,
> > Recenty, I met with a serious problem. For some unknown reason, the
> > log file of one of our database is missing, only the data file left.
> > Can I just use the data file of the database to restore the database?
> > Thanks.
> > Dobby
> > Ps: I use SQL Server 2000
use sp_attach_single_file_db option to attach the datafile which will
automatically creates your log file.
EXEC sp_attach_single_file_db @.dbname = 'pubs',
@.physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data
\pubs.mdf'
Thanks
Vijayasekar|||On Oct 4, 7:40 pm, vijay <vjsek...@.gmail.com> wrote:
> On Oct 4, 2:33 pm, Dmitrij Siemieniako
> <DmitrijSiemieni...@.discussions.microsoft.com> wrote:
> > Try sp_attach_single_file_db. More information in BOL.
> > Dmitrij
> > "Dobby Cai" wrote:
> > > Hi All,
> > > Recenty, I met with a serious problem. For some unknown reason, the
> > > log file of one of our database is missing, only the data file left.
> > > Can I just use the data file of the database to restore the database?
> > > Thanks.
> > > Dobby
> > > Ps: I use SQL Server 2000
> use sp_attach_single_file_db option to attach the datafile which will
> automatically creates your log file.
> EXEC sp_attach_single_file_db @.dbname = 'pubs',
> @.physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data
> \pubs.mdf'
> Thanks
> Vijayasekar
Thanks you for all, I will try this method.