November 22, 2009 at 9:16 pm
hi,
iam facing an issue,with missing database file,how to trouble shoot with this issue and get back the missing file?,could any give solution for this
thanks
Koteswar Rao
November 22, 2009 at 11:11 pm
Hi, please provide more detail?
which database? system? which file? mdf, ldf? etc....
any backups made recently?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 23, 2009 at 12:15 am
Hi,
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
and one more
how to recover the accidently deleted job by one of the user?
November 23, 2009 at 12:49 am
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
and one more
how to recover the accidently deleted job by one of the user?
can you clarify this? has a job been deleted or has the database mdf been deleted.
option A: (in the event of mdf been deleted)
restore from you (hopefully) FULL backup.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 23, 2009 at 1:19 am
y.koteswarrao-652921 (11/23/2009)
yes, recently i have taken full database backup and i missed .mdf file,how to recover it?
Can you explain in more detail what you've done, what happened and what you need? I don't understand the question
how to recover the accidently deleted job by one of the user?
Asked and answered: http://www.sqlservercentral.com/Forums/Topic823111-265-1.aspx
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 23, 2009 at 9:35 pm
Hopefully if you have a full database backup you will be able to restore. Restoring the job please check the MSDB database this might help.
check the following views:
sysmaintplan_plans
sysjobs_view
sp_help_jobactivity
Cheers,
Got an idea..share it !!
DBA_Vishal
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply