Database shows in read only mode ?

Database shows in read only mode when I did try to restore my database.But How to can I convert it to online mode?

pls help

Hi,

You can leave a restored database in one of the following states:

Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY) Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY) Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH STANDBY)

Database set to simple recovery

Hello I want to perform a transaction log backup for disaster recovery every
30min. Because the recovery mode is set to simple it is not allowing me to
to do this.
My questions are;
1. What are the beneifits of a simple recovery? My transaction log still gro
ws very large.
2. What are the benefits of performing a transaction log backup?
3. Do I have to detach the database to change from simple to full recovery?
ThanksPlease read the page titled "Selecting a Recovery Model" in SQL Server 2000
Books Online. This answers most of your questions.
Transaction log backups help you recover to a point-in-time, and no, you
don't have to detach the database, to change the recovery mode. See ALTER
DATABASE command in SQL Server Books Online for more information on changing
recovery models of databases.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:E055BCF9-34BE-45DE-BE89-62C56AF61E11@.microsoft.com...
Hello I want to perform a transaction log backup for disaster recovery every
30min. Because the recovery mode is set to simple it is not allowing me to
to do this.
My questions are;
1. What are the beneifits of a simple recovery? My transaction log still
grows very large.
2. What are the benefits of performing a transaction log backup?
3. Do I have to detach the database to change from simple to full recovery?
Thanks

Database set to simple recovery

Hello I want to perform a transaction log backup for disaster recovery every 30min. Because the recovery mode is set to simple it is not allowing me to to do this.
My questions are;
1. What are the beneifits of a simple recovery? My transaction log still grows very large.
2. What are the benefits of performing a transaction log backup?
3. Do I have to detach the database to change from simple to full recovery?
Thanks
Please read the page titled "Selecting a Recovery Model" in SQL Server 2000
Books Online. This answers most of your questions.
Transaction log backups help you recover to a point-in-time, and no, you
don't have to detach the database, to change the recovery mode. See ALTER
DATABASE command in SQL Server Books Online for more information on changing
recovery models of databases.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"robert salazar" <rsalazar@.cbbank.com> wrote in message
news:E055BCF9-34BE-45DE-BE89-62C56AF61E11@.microsoft.com...
Hello I want to perform a transaction log backup for disaster recovery every
30min. Because the recovery mode is set to simple it is not allowing me to
to do this.
My questions are;
1. What are the beneifits of a simple recovery? My transaction log still
grows very large.
2. What are the benefits of performing a transaction log backup?
3. Do I have to detach the database to change from simple to full recovery?
Thanks

DAtabase Recovery from emergency mode

We had a RAID breakdown that brought around 20 of our
databases each around 100 GB in Emergency mode.
What is the best way to recover the database.
We have tried the method of renaming the database files
and log files and running the following set of commands:-
sp_configure 'allow updates', 1
go
reconfigure with override
go
use master
go
Update sysdatabases set status = 32768 where name = 'TEST'
go
sp_configure 'allow updates', 0
go
reconfigure with override
But when we try to re gendrate the logs it fails with the
DBNETLIB error.
How shoule we procede to recover the databasesrecreate the RAID and attach the databases. There is also a way to reset the database state in the configuration table.
rgn|||The best way is from good backups. If your Raid crashed that hard you can
not be sure of the integrity of the files and restoring from backups is the
proper way to recover them.
--
Andrew J. Kelly
SQL Server MVP
"YOGI.GUPTA@.MAIL.SPRINT.COM" <anonymous@.discussions.microsoft.com> wrote in
message news:019001c3ca6e$92327720$a401280a@.phx.gbl...
> We had a RAID breakdown that brought around 20 of our
> databases each around 100 GB in Emergency mode.
> What is the best way to recover the database.
> We have tried the method of renaming the database files
> and log files and running the following set of commands:-
> sp_configure 'allow updates', 1
> go
> reconfigure with override
> go
> use master
> go
> Update sysdatabases set status = 32768 where name = 'TEST'
> go
> sp_configure 'allow updates', 0
> go
> reconfigure with override
> But when we try to re gendrate the logs it fails with the
> DBNETLIB error.
> How shoule we procede to recover the databases
>

database quiescing mode

I do have a question that I searched the book but not found answer. As you
know Oracle or DB2 has a feature called database quiescing mode, that can
put database in such state that transactions are temporarily staged,
providing certain time for database snapshot or replication. After the
snapshot is done the quiescing mode can be disabled and all paused
transactions are committed into database. Does SQL 2005 have similar
feature? If not what 3rd party software as you know can mimic the
operation?SQL Server has supported quiescing I/Os for a long time (since SQL 7.0 at
least). In SQL2000 Books Online, type Snapshot backup on the Index tab. On
the Microsoft website, search for VDI (virtual device interface). For
instance, here's the SQL2005 VDI specs
http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&DisplayLang=en.
Third-party tools such as EMC TimeFinder all leverage SQL Server quiesceing
capability when doing snapshot backups.
Linchi
"Rustom" wrote:
> I do have a question that I searched the book but not found answer. As you
> know Oracle or DB2 has a feature called database quiescing mode, that can
> put database in such state that transactions are temporarily staged,
> providing certain time for database snapshot or replication. After the
> snapshot is done the quiescing mode can be disabled and all paused
> transactions are committed into database. Does SQL 2005 have similar
> feature? If not what 3rd party software as you know can mimic the
> operation?
>
>|||The VSS writer service does that for the Windows Volume Shadow Service in
SQL 2005.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:13B181C1-6F6C-4320-9545-25749A954C2E@.microsoft.com...
> SQL Server has supported quiescing I/Os for a long time (since SQL 7.0 at
> least). In SQL2000 Books Online, type Snapshot backup on the Index tab. On
> the Microsoft website, search for VDI (virtual device interface). For
> instance, here's the SQL2005 VDI specs
> http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&DisplayLang=en.
> Third-party tools such as EMC TimeFinder all leverage SQL Server
> quiesceing
> capability when doing snapshot backups.
> Linchi
> "Rustom" wrote:
>> I do have a question that I searched the book but not found answer. As
>> you
>> know Oracle or DB2 has a feature called database quiescing mode, that can
>> put database in such state that transactions are temporarily staged,
>> providing certain time for database snapshot or replication. After the
>> snapshot is done the quiescing mode can be disabled and all paused
>> transactions are committed into database. Does SQL 2005 have similar
>> feature? If not what 3rd party software as you know can mimic the
>> operation?
>>