Restore default setting for MSDE

How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode? And to have my sa account withoutpassword? Please help me! Thanks, Nibbles

Nibbles wrote:

How can I restore the default setting for MSDE to have only WindowsAutentication and not mixed mode?

This setting cannot be changed with T-SQL as far as I know. Youcan do it with Enterprise Manager, or with your own custom SQL-DMOprogram, or by changing the registry directly.

Nibbles wrote:

And to have my sa account withoutpassword?

Never ever leave the sa account without a pasword! You can change the password using thesp_password system stored procedure.
You will find this article helpful as it addresses both of your needs:How To Verify and Change the MSDE System Administrator Password
sql

Restore Database in Standby without a Transaction undo file

Is there a way to restore a database that is in stand-by mode, if the TUF
file has become corrupted or accidently deleted.
If you do a resotre database with recovery you will get an error saying the
file is not accessiable. Is there a way to force the restore.
You can stop SQL, copy the files and re-attach I think.
It would also be nice if SQL could backup database that are in standby. This
way you can do quick offsite backups.
Hi,
AFAIK, IF the TUF file (undo file) is corrupted or lost you can not restore
the subsequent transaction logs in to your database which is in
stand by mode.
Thanks
Hari
SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.
|||If the standby file is hosed, so are you. I submitted a SQLWISH a while ago
for SQL Server to lock the standby file just as it does any SQL database
file. I don't know the status of that request.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.

Restore Database in Standby without a Transaction undo file

Is there a way to restore a database that is in stand-by mode, if the TUF
file has become corrupted or accidently deleted.
If you do a resotre database with recovery you will get an error saying the
file is not accessiable. Is there a way to force the restore.
You can stop SQL, copy the files and re-attach I think.
It would also be nice if SQL could backup database that are in standby. This
way you can do quick offsite backups.Hi,
AFAIK, IF the TUF file (undo file) is corrupted or lost you can not restore
the subsequent transaction logs in to your database which is in
stand by mode.
Thanks
Hari
SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.|||If the standby file is hosed, so are you. I submitted a SQLWISH a while ago
for SQL Server to lock the standby file just as it does any SQL database
file. I don't know the status of that request.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.

Restore Database in Standby without a Transaction undo file

Is there a way to restore a database that is in stand-by mode, if the TUF
file has become corrupted or accidently deleted.
If you do a resotre database with recovery you will get an error saying the
file is not accessiable. Is there a way to force the restore.
You can stop SQL, copy the files and re-attach I think.
It would also be nice if SQL could backup database that are in standby. This
way you can do quick offsite backups.Hi,
AFAIK, IF the TUF file (undo file) is corrupted or lost you can not restore
the subsequent transaction logs in to your database which is in
stand by mode.
Thanks
Hari
SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.|||If the standby file is hosed, so are you. I submitted a SQLWISH a while ago
for SQL Server to lock the standby file just as it does any SQL database
file. I don't know the status of that request.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"et" <et@.discussions.microsoft.com> wrote in message
news:A59EF3D5-08C9-4A69-A97F-10EEBAB112B2@.microsoft.com...
> Is there a way to restore a database that is in stand-by mode, if the TUF
> file has become corrupted or accidently deleted.
> If you do a resotre database with recovery you will get an error saying
> the
> file is not accessiable. Is there a way to force the restore.
> You can stop SQL, copy the files and re-attach I think.
> It would also be nice if SQL could backup database that are in standby.
> This
> way you can do quick offsite backups.

Restore database and trx log

Hi:
My db is set to full recovery mode. Do i need to restore the latest
transaction log after restore a latest complete db backup ?
eg:
1.00pm Trx log backup
2.00pm Complete db backup
3.00pm Trx log backup
There is no activity after 2.00pm, when i restore the 2.00pm db backup
to another server, do i need to restore 3.00pm trx log backup ? Will
the complete db backup include the data between 1.00pm and 2.00pm ?
Please help.
Thanks
JCVoonHi
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
No. Even though you restore full backup from ther previous week and
applied all log files including this one made on 1PM you will not have the
data between 1PM and 2PM.
If it is crtical for you so consider backu log file every 15 minute for
exampe
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegroups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>|||The database backup made a 2pm will include all transactions up through 2
pm. If you restore the backup with recovery, you should have the database as
it was as of 2 pm.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegroups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>|||Uri Dimant, Kalen Delaney:
Thanks for the quick reply.
I did a small test, i create a new db and pump in some data, then i
perform a trxlog backup, after the log backup, i pump in another chunk
of data, then i perform full db backup, i restore the full db backup to
another db and i notice that the data that i insert after the 1st
trxlog backup is exist in the new db. But my customer complain that
after he restore the full db backup, data enterd before full db backup
is not exist ! Can u please explain what is going wrong ?
Thanks
JCVoon|||maybe when you perform full db backup, the transaction is not yet committed
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||Can you provide a script yopu tested on?
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||> But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist !
That does not happen. Most likely they restored incorrectly. Perhaps they ap
pended to the backup
file (?) and then restored one of the older backups on that file? Use RESTOR
E HEADERONLY to
investigate, and the FILE option of the restore command to specify which to
restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||Tibor Karaszi:
Thanks for your reply.
So i can confirm that restoring the full db backup will bring the db to
the state that i perform the full db backup right ?
Any for the uncommitted transaction during the full db backup, i have
to backup the trxlog after perform the full db backup and apply it to
the new db right ?
Thanks
JCVoon|||Atenza:
This make sense.
Thanks.
JCVoon|||Hi
When database is restoring CHECKPOINT occures. It checks what transactions
to undo or redo
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142844757.254805.129640@.i39g2000cwa.googlegroups.com...
> Tibor Karaszi:
> Thanks for your reply.
> So i can confirm that restoring the full db backup will bring the db to
> the state that i perform the full db backup right ?
> Any for the uncommitted transaction during the full db backup, i have
> to backup the trxlog after perform the full db backup and apply it to
> the new db right ?
> Thanks
> JCVoon
>

Restore database and trx log

Hi:
My db is set to full recovery mode. Do i need to restore the latest
transaction log after restore a latest complete db backup ?
eg:
1.00pm Trx log backup
2.00pm Complete db backup
3.00pm Trx log backup
There is no activity after 2.00pm, when i restore the 2.00pm db backup
to another server, do i need to restore 3.00pm trx log backup ? Will
the complete db backup include the data between 1.00pm and 2.00pm ?
Please help.
Thanks
JCVoonHi
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
No. Even though you restore full backup from ther previous week and
applied all log files including this one made on 1PM you will not have the
data between 1PM and 2PM.
If it is crtical for you so consider backu log file every 15 minute for
exampe
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegroups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>|||The database backup made a 2pm will include all transactions up through 2
pm. If you restore the backup with recovery, you should have the database as
it was as of 2 pm.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegroups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>|||Uri Dimant, Kalen Delaney:
Thanks for the quick reply.
I did a small test, i create a new db and pump in some data, then i
perform a trxlog backup, after the log backup, i pump in another chunk
of data, then i perform full db backup, i restore the full db backup to
another db and i notice that the data that i insert after the 1st
trxlog backup is exist in the new db. But my customer complain that
after he restore the full db backup, data enterd before full db backup
is not exist ! Can u please explain what is going wrong ?
Thanks
JCVoon|||maybe when you perform full db backup, the transaction is not yet committed
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||Can you provide a script yopu tested on?
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||> But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist !
That does not happen. Most likely they restored incorrectly. Perhaps they appended to the backup
file (?) and then restored one of the older backups on that file? Use RESTORE HEADERONLY to
investigate, and the FILE option of the restore command to specify which to restore.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegroups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>|||Tibor Karaszi:
Thanks for your reply.
So i can confirm that restoring the full db backup will bring the db to
the state that i perform the full db backup right ?
Any for the uncommitted transaction during the full db backup, i have
to backup the trxlog after perform the full db backup and apply it to
the new db right ?
Thanks
JCVoon|||Atenza:
This make sense.
Thanks.
JCVoon|||Hi
When database is restoring CHECKPOINT occures. It checks what transactions
to undo or redo
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142844757.254805.129640@.i39g2000cwa.googlegroups.com...
> Tibor Karaszi:
> Thanks for your reply.
> So i can confirm that restoring the full db backup will bring the db to
> the state that i perform the full db backup right ?
> Any for the uncommitted transaction during the full db backup, i have
> to backup the trxlog after perform the full db backup and apply it to
> the new db right ?
> Thanks
> JCVoon
>|||Correct.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142844757.254805.129640@.i39g2000cwa.googlegroups.com...
> Tibor Karaszi:
> Thanks for your reply.
> So i can confirm that restoring the full db backup will bring the db to
> the state that i perform the full db backup right ?
> Any for the uncommitted transaction during the full db backup, i have
> to backup the trxlog after perform the full db backup and apply it to
> the new db right ?
> Thanks
> JCVoon
>

Restore database and trx log

Hi:
My db is set to full recovery mode. Do i need to restore the latest
transaction log after restore a latest complete db backup ?
eg:
1.00pm Trx log backup
2.00pm Complete db backup
3.00pm Trx log backup
There is no activity after 2.00pm, when i restore the 2.00pm db backup
to another server, do i need to restore 3.00pm trx log backup ? Will
the complete db backup include the data between 1.00pm and 2.00pm ?
Please help.
Thanks
JCVoon
Hi
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
No. Even though you restore full backup from ther previous week and
applied all log files including this one made on 1PM you will not have the
data between 1PM and 2PM.
If it is crtical for you so consider backu log file every 15 minute for
exampe
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegr oups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>
|||The database backup made a 2pm will include all transactions up through 2
pm. If you restore the backup with recovery, you should have the database as
it was as of 2 pm.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142835431.892296.151550@.z34g2000cwc.googlegr oups.com...
> Hi:
> My db is set to full recovery mode. Do i need to restore the latest
> transaction log after restore a latest complete db backup ?
> eg:
> 1.00pm Trx log backup
> 2.00pm Complete db backup
> 3.00pm Trx log backup
> There is no activity after 2.00pm, when i restore the 2.00pm db backup
> to another server, do i need to restore 3.00pm trx log backup ? Will
> the complete db backup include the data between 1.00pm and 2.00pm ?
> Please help.
>
> Thanks
> JCVoon
>
|||Uri Dimant, Kalen Delaney:
Thanks for the quick reply.
I did a small test, i create a new db and pump in some data, then i
perform a trxlog backup, after the log backup, i pump in another chunk
of data, then i perform full db backup, i restore the full db backup to
another db and i notice that the data that i insert after the 1st
trxlog backup is exist in the new db. But my customer complain that
after he restore the full db backup, data enterd before full db backup
is not exist ! Can u please explain what is going wrong ?
Thanks
JCVoon
|||maybe when you perform full db backup, the transaction is not yet committed
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegr oups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>
|||Can you provide a script yopu tested on?
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegr oups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>
|||> But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist !
That does not happen. Most likely they restored incorrectly. Perhaps they appended to the backup
file (?) and then restored one of the older backups on that file? Use RESTORE HEADERONLY to
investigate, and the FILE option of the restore command to specify which to restore.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142839424.157319.177960@.i40g2000cwc.googlegr oups.com...
> Uri Dimant, Kalen Delaney:
> Thanks for the quick reply.
> I did a small test, i create a new db and pump in some data, then i
> perform a trxlog backup, after the log backup, i pump in another chunk
> of data, then i perform full db backup, i restore the full db backup to
> another db and i notice that the data that i insert after the 1st
> trxlog backup is exist in the new db. But my customer complain that
> after he restore the full db backup, data enterd before full db backup
> is not exist ! Can u please explain what is going wrong ?
> Thanks
> JCVoon
>
|||Tibor Karaszi:
Thanks for your reply.
So i can confirm that restoring the full db backup will bring the db to
the state that i perform the full db backup right ?
Any for the uncommitted transaction during the full db backup, i have
to backup the trxlog after perform the full db backup and apply it to
the new db right ?
Thanks
JCVoon
|||Atenza:
This make sense.
Thanks.
JCVoon
|||Hi
When database is restoring CHECKPOINT occures. It checks what transactions
to undo or redo
"jcvoon" <jcvoon@.maximas.com.my> wrote in message
news:1142844757.254805.129640@.i39g2000cwa.googlegr oups.com...
> Tibor Karaszi:
> Thanks for your reply.
> So i can confirm that restoring the full db backup will bring the db to
> the state that i perform the full db backup right ?
> Any for the uncommitted transaction during the full db backup, i have
> to backup the trxlog after perform the full db backup and apply it to
> the new db right ?
> Thanks
> JCVoon
>

restore database

hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)

Quote:

Originally Posted by deepji2007

hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)

The master database contains information about every other DB in the system.

Therefore in order to overwrite it, it has to be in a special mode where only one string of information could possibly be coming in.

To start SQL Server in single user mode, stop the SQL server and start it again using this command.

sqlservr -m

If this doesnt work, try browsing to the \Microsoft SQL Server\80\Tools\binn directory.

**note overwriting your master database can be very dangerous. Only do this if its completely necessary.|||hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)|||

Quote:

Originally Posted by deepji2007

hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)

From a command prompt type:

C:\> CD program files\microsoft sql server\80\tools\binn

C:\> sqlservr -m