April 2, 2010 at 12:31 am
How to take T-Log backup if my database is inaccessible?
April 2, 2010 at 1:08 am
You need to establish why the database is unavailable, is there anything in the SQL Server log or event viewer that suggests why it is unavailable. You can try the following T-SQL to backup the transaction log
use master
go
BACKUP LOG [DB_NAME] TO DISK = N'D:\BACKUP\T_LOG_BackupNme.trn'
GO
Gethyn Elliswww.gethynellis.com
April 2, 2010 at 1:13 am
My server got rebooted & after that database is showing in "Restoring" mode. No info in logs.
April 2, 2010 at 1:44 am
Was a restore taking place when the reboot happened?
A database in a restoring state usually indicates that a restore has taken place with the NO RECOVERY OPTION specified usually so other files can be applied in bringing the database back to a point in time.
Gethyn Elliswww.gethynellis.com
April 2, 2010 at 2:32 am
- keep in mind you should refresh your object browser frequently (afaik it doens't auto refresh)
- after start of sqlserver each db is being recovered.
So sqlserver opens the db and will execute the db-log roll forward and roll back. During this periode your db will be in recovery mode until it completes.
(it should report % completed in its errolog)
Is your db still in recovery state ?
Post your sqlserver errorlog file. Maybe we can help out.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply