April 30, 2010 at 8:19 am
is there anyway in SQL Server to tell whether a database was renamed. I have searched sql server error logs but dont see any info about this.
April 30, 2010 at 8:36 am
Do you have a baseline, you can compare against.
Do you have a list of your Database changes.
check the Default trace for answers, if it is not too late... they are in the Log folder.
Maninder
www.dbanation.com
April 30, 2010 at 8:42 am
I am trying to open available .trc files but get access denied error. Not sure why that is.
April 30, 2010 at 8:49 am
Try Copying the File to another Location and then open the File. Or Do not copy the current File, else copy everything to diff location and try to open the file.
Or Stop the TRace and then Copy the Files over to diff loc.
select * from fn_trace_getinfo(default)
Maninder
www.dbanation.com
April 30, 2010 at 9:16 am
trace files dont go back to last week when the changed happened. any other place I look?
April 30, 2010 at 10:37 am
window event viewer / SQL Error Log /SQL Trace and that is as far as we can look into.
Was this database associated with any jobs.
I suppose this database was in the maintenance plan. did the maintenance ever failed, because of the change.
Maninder
www.dbanation.com
April 30, 2010 at 12:30 pm
yuppp.... thats what happened
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply