November 27, 2008 at 5:33 am
Hi Every body,
My database backup job faile
Every day 12 Am take full backup
Every one hour will take differntial backup
Everu 1/2 hour will take T-log backup
my database job faile due to some network proublems
& My T-log log file actual size is 10gb only but now it is showing 38 GB
and my sql Server services are starting automatically
and i have shrink it again my system is automatically restat
1st how can take a bacup please any body explaine me
really appriciate to you
Thanks
November 27, 2008 at 6:14 am
Which of your backups are failing?
Where are the backups been written to?
What's the error message?
How long have the backups been failing for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2008 at 7:15 am
Hi
Thanks u for ur reply
Which of your backups are failing? T-Log fail
Where are the backups been written to? os error
What's the error message? network error 11745
How long have the backups been failing for? just two hours back only
i am planning to resote all backups
can you please suggest how to recove as per my database schedule
plz help me
November 27, 2008 at 7:29 am
kumar99ms (11/27/2008)
Where are the backups been written to? os error
Where are the backups been written to?
(Local drive, network drive, tape, DVD, flash drive, etc)
What's the error message? network error 11745
Full error message please. With the text.
i am planning to resote all backups
Resote? What does that mean?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2008 at 7:57 am
Hi Gail
Thank u for reply
i had restore to local drive only i
but i am very new to do this work .net guy could please help me with step by step
How can i restore it .............:D
November 27, 2008 at 8:06 am
I'll help you if you can answer my questions please. Right now I don't know what you're trying to do or what errors you're getting.
Why are you trying to restore when you have backups failing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply