|
Home > Archive > MS SQL Server > October 2006 > A Database was delete
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A Database was delete
|
|
| Vito Corleone 2006-10-24, 6:31 pm |
| Bon Journal,
Mama Mia! Helppa me.
One na of my boysa had da accidently deleted a databasesa fromma MS SQL 2000
Serversa. None of themma hassa comema forwardsa yetta.
Are there anywhere in master or mdb or model or other ways that I can write
a query that will give me records or traces back to 1 month ago or 2 months
ago? Is there any where in MS SQL 2000 Server that I can dig up some dirts?
My SQL Log is currently holding on 6 days.
I justa wanta to finda outa whenna wassa this databasesa , the deleted
databasesa, was created and deleted before someone na gitta a dead da fish.
Grascia,
Vito Corleone.
| |
| Tibor Karaszi 2006-10-24, 6:31 pm |
| SQL Server 2000 doesn't store that information, so unless you had a profiler trace running you are
probably out of luck. SQL Server 2005 keep track of this in the default trace which is running by
default.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Vito Corleone" < VitoCorleone@discuss
ions.microsoft.com> wrote in message
news:3E08F799-7713-4FBE-85A1- C5E7BDC29D1F@microso
ft.com...
> Bon Journal,
>
> Mama Mia! Helppa me.
>
> One na of my boysa had da accidently deleted a databasesa fromma MS SQL 2000
> Serversa. None of themma hassa comema forwardsa yetta.
>
> Are there anywhere in master or mdb or model or other ways that I can write
> a query that will give me records or traces back to 1 month ago or 2 months
> ago? Is there any where in MS SQL 2000 Server that I can dig up some dirts?
> My SQL Log is currently holding on 6 days.
>
> I justa wanta to finda outa whenna wassa this databasesa , the deleted
> databasesa, was created and deleted before someone na gitta a dead da fish.
>
> Grascia,
> Vito Corleone.
| |
| Vito Corleone 2006-10-24, 6:31 pm |
| Hello Tibor,
Thank you very mooch.
Vito Corleone
"Tibor Karaszi" wrote:
> SQL Server 2000 doesn't store that information, so unless you had a profiler trace running you are
> probably out of luck. SQL Server 2005 keep track of this in the default trace which is running by
> default.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Vito Corleone" < VitoCorleone@discuss
ions.microsoft.com> wrote in message
> news:3E08F799-7713-4FBE-85A1- C5E7BDC29D1F@microso
ft.com...
>
>
|
|
|
|
|