March 14, 2013 at 12:07 am
HI to all,
Server is getting restarted whenever we are running the SQL Backup [scheduled backup maintenance plan job and also tried manually ]. This issue has started after the storage migration activity.
1. on the daily monitoring basis i check the scheduled backup job at 10 am which is not executing nor giving any errors and in job activity monitor also job is not showing failed status and at the same time 10am daily server is rebooting no errors are identified in windows or in sqlserver logs.
2. I tried to execute the backup from job activity monitor -- start job at a step
3. from data base right click --- tasks --- backup
4. management---- maintenance plan ---- execute
all the possible ways i tried to take backup but after some time backup running and server is rebooting
what should we do in this scenario to solve this
Thanks
Naga.Rohitkumar
March 14, 2013 at 12:18 am
Is it throwing any errors into the error logs? Please post the errors.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 14, 2013 at 1:17 am
its not posting any errors in event viewer or in sql server error logs both dba and wintel team is working from 2days on this to stop server rebooting at backup time from my end i disabled all the maintenance plan backup jobs...what is the actual reason unable to find we suspect after the activity storage migration its happening mainly
Thanks
Naga.Rohitkumar
March 14, 2013 at 10:14 am
No errors posted in any log?
Not in the storage logs?
Not in the OS logs?
Not in the SQL logs?
If not in any of those places, then maybe somebody has created a nasty alert that fires off a server shutdown any time a backup is created.
Maybe there is a scheduled reboot task in the windows scheduler.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 14, 2013 at 11:06 pm
nobody has created any of the schedules coz its occuring a the time of running backup manually or by scheduled backup jobs
it is in cluster also and it is giving failure audit of another node AP server failure log in DB server event viewer
we tried to take backup in both node [DB and AP servers ] at both it is rebooting and givng blue dump in windows. there also unable to find the errors
my exp is very less and so iam unable to find the root cause but iam trying my level best this is the site which made me to know more when ever a issue comes
Thanks
Naga.Rohitkumar
March 15, 2013 at 8:42 am
Do you show any errors on the SAN side? is it dropping the luns due to too much data change or a journal getting full? If it happens after some time, i doubt it would be something like a shutdown trigger... if the SAN was recently changed, I'd look at what they're doing. Do you have the option at least to add a physical drive to the server to get a good backup going? maybe see if backing up to a physical drops you or not (if one is easy to obtain)
.
March 15, 2013 at 10:11 am
naga.rohitkumar (3/14/2013)
nobody has created any of the schedules coz its occuring a the time of running backup manually or by scheduled backup jobsit is in cluster also and it is giving failure audit of another node AP server failure log in DB server event viewer
we tried to take backup in both node [DB and AP servers ] at both it is rebooting and givng blue dump in windows. there also unable to find the errors
my exp is very less and so iam unable to find the root cause but iam trying my level best this is the site which made me to know more when ever a issue comes
What commands are you using to run a manual backup?
The blue screen and windows dump is an issue. This would generate logs and dmp files. When a blue screen occurs, I'd be more focused on the hardware, drivers, or windows installation.
Post the actual backup command you are using. It is possible that due to a driver misconfiguration or failing hardware that the IO load from a backup will provoke a blue screen. But for that there would be some information in the windows logs, dump files or possibly in the SAN logs.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 20, 2013 at 1:11 am
Hi SQLRNNR & Bill
Thanks for your replies issues is partially solved here i'am giving description and also can you please suggest why it is solved ?
1. we didn't find any root cause and errors from any side but after deep monitoring in the server from wintel steam had updated firmware later from DB end i tried to take backup manually to check whether the server is rebooting now also.. but the one of the database backup is executed and in the properties of the job we find the owner has changed and by comparing the job which has success we changed and tried to take backup then it also executed [these two databases are user databases ]
2. in system database[master.model,msdb] maintenance plan backup jobs are continuesly failing even after checking all the permissions correct
1. then i disabled the current one and created a duplicate backup
maintenance plan and tried to execute it went success and the .BAk files is available for current time similarly created for every one and scheduled also whether its working or not ... it is succeeded
2. deleted all jobs and freshly created and checked its working and
now it is under monitoring for few days
3. can any one say why it got succeeded and what is the actual cause because i want to know the root cause.
"some times right things get wrong and wrong one clicks "
Thanks
Naga.Rohitkumar
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply