March 17, 2009 at 10:43 pm
Hello All, I am using ASP.NET and SQLSERVER at Back Hand,
I have Hosted all my sites around 250 sites, but i have hosted the Databases of all of these in another Server which is purchased.
Our data center are using Dedicated server with MS Standard License version and on this server around 250 databases and only the issue occurred our with four databases.The Issue is that after some times all the Database Tables and Store Procedure are dropped automatically. I don't know what is the problem causing this. Our other databases are running fine.
Is the Database is corrupted?
If yes then how automatically Database corrupted?
Please Help me because these are live sites.
March 18, 2009 at 12:22 am
The Issue is that after some times all the Database Tables and Store Procedure are dropped automatically. I don't know what is the problem causing this.
Strange...check if any job is doing this.Run profiler and catch for the events which is causing this.Also check the event viewer logs.
Profiler is the best thing for you.
March 18, 2009 at 12:41 am
Thanks for your reply,
Strange...check if any job is doing this.Run profiler and catch for the events which is causing this.Also check the event viewer logs.
Profiler is the best thing for you.
I have already said that the Database is host on another server, which is purchased by third party, and they are saying that there is nothing job and scheduling in this server.
How to run Profiler?
March 18, 2009 at 12:50 am
How to run Profiler?
go to performance tools-->sql profiler
open new trace and give the authentication for that server.
leave everything to default and click the "Run".Later stop the trace and search for the events you need using ctrl+F.
you can also filter the events to required databases.
March 18, 2009 at 12:52 am
If it isn't jobs or someone idea of a really bad joke. The account accessing the database does it have DBO permissions? Is your website SQL Injection proof?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 18, 2009 at 1:09 am
go to performance tools-->sql profiler
open new trace and give the authentication for that server.
leave everything to default and click the "Run".Later stop the trace and search for the events you need using ctrl+F.
you can also filter the events to required databases.
Thanks agian,
My Database is hosted at server and i am using Express Edition for Development. I am try to Download SQl Profiler.
If it isn't jobs or someone idea of a really bad joke. The account accessing the database does it have DBO permissions? Is your website SQL Injection proof?
Mohit.
Hello Mohit,
Yes.
and I am using Stored Procedure
March 18, 2009 at 1:21 am
Ask your vendor to check default trace log; object drop/creation are logged in there.
And by default up to 5 old trace logs are left.... so there might be something in there on how/who is doing it.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 18, 2009 at 1:26 am
Hello i have INstalled SqlExpressProfiler.exe
Then i have authenticated sucessfully but then i am getting this error,
version: 0.1.5.20
exception: System.Data.SqlClient.SqlException: You do not have permission to run 'SP_TRACE_CREATE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
March 18, 2009 at 1:29 am
You don't have Trace permissions on SQL Server.
Ask your vendor to execute
USE MASTER
GO
GRANT ALTER TRACE LoginName
GO
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 18, 2009 at 1:43 am
OK Mohit I will ask vendor then tell you.
Thanks both of you.
March 18, 2009 at 6:15 am
Just a note of caution, running the Profiler gui on a production system can be very problematic[/url]. Best practice is to use a server-side trace to gather the data and the Profiler simply to look at it once it's gathered.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply