Yes Adam. Do you see any caveats in doing so.

Thank you Noel & Others who have responded to my questions.

1. In Oracle, we can take a logical backup of the database using 'exp' command which will get the data...

Thank you Andras. Is there a way to avoid manual checking. Since it will not be possible to keep checking the error log manually frequently, is there any tool which...

I am in the process of establishing a Recovery case scenario just in case the hardware crashes and i need to recreate the SQL Server db

MDaniel

I will try this and get back to you. Thanks

Hello

Thanks for the quick reply. I am trying to test the recovery of the master db.

I read through the following link(s)

http://msdn2.microsoft.com/en-us/library/aa173515(SQL.80).aspx

http://www.dbarecovery.com/restoremasterdb.html which is from

http://www.google.com/search?hl=en&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=master+db+in+single+user+mode&spell=1

The problem...

I found it.. I had to change the RECOVERY MODEL to FULL (instead of SIMPLE) under the database OPTIONS. That did it!!!.

Thanks for all the help.

Hello Lowell

You were correct in saying that. Thanks for that. Now the full database backup is running for all the databases successfully but the transaction log is getting backed up...

Why are you saying "use master" prior to BACKUP LOG YOUR_DATABASE_NAME WITH TRUNCATE_ONLY? I don't understand this part.. what is the role of the master database here? Last time i...

The backup is working fine and the transaction log is getting shrunk. However, i would need to lift the limit on the Trn.log upper limit.

Thanks to all for the suggestions....

Using the "Database Maintenance Plans" GUI i scheduled the full backup once a day and the transaction log once every 4 hours. The GUI wizard shows provision for auto shrink...

Does sql server release blocks from the logfile once it writes to the database?

OR

does it write to the database file only when the db is backed up?

OR

when the...

Hello SQLBill

Thanks for the suggestion. Since my work exp with SQL-Server is only few days i would require assistance from you experts.

 My database was in FULL mode. I set the...

Also, i would appreciate if the following can be clarified too?

- Is it a must that i must backup the log file prior to doing DBCC? I don't have that...