How to check sql server 2000 still receive data

Question

Post reply

How to check sql server 2000 still receive data

Ed7

SSCrazy Eights

Points: 8519
More actions
February 4, 2010 at 12:25 pm

#386244

SQL Guru,
I would like to check the sql server 2000 database still received data from custom apps
Can someone please let me know.
Thanks,
Edwin

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Some of the things that you can do is run profiler and look in the Text Column for DML.

Capture those DML statement to insure that the operation was performed.

You can also check the last record(s) in the table that the application is inserting records into prior to and running your application. Then you check again after the application performs it's routing to insert, update or delete.

You can run DBCC INPUT BUFFER(SPID) and obtain the actual Statement. This will list the application program, the command being executed and the SPID (Systerm Process ID) e.g. 86

You may also try the DBCC INPUTBUFFER(86)

Displays:

EXEC usp_MyProc

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 2

Hi Welsh,

I did perform the step #2 that you mentioned on the discuss

SELECT TOP 10 * FROM Table_A

ORDER BY ROW_1 DESC

Questions and Discussion:

The SQL 2000 database was setup with the simple recovery model.

The database was setup by someone (Developer team) and they maintenance it.

Until Last week, the database was corrupted due to disk failure. They called me out to fixed it on Saturday. So, I recover the database from last backup file.

What is the Microsoft recommended good practices to cope this kind of scenario?

Thanks,

Edwin

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Edwin-376531 (2/5/2010)
What is the Microsoft recommended good practices to cope this kind of scenario?

A good backup strategy designed according to the downtime and data loss requirements of the application.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 4

Can you explain in detail?

In addition, should the sql database recover model set to Full?

So, I can back up the transaction logs?

If the database setup full recover model, the transaction log will grow.

What are best practive recommandation to deal with those logs?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Edwin-376531 (2/5/2010)
In addition, should the sql database recover model set to Full?
So, I can back up the transaction logs?

Depends. If it's necessary to be able to restore the DB to the point of failure, then yes.

If the database setup full recover model, the transaction log will grow.
What are best practive recommandation to deal with those logs?

Please read through this - Managing Transaction Logs[/url]

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 6

Hi Gail,

Thanks for the Managing Transaction Logs article and it was very helpful.

I reported a new IT manager and be asked to provide DR plan on eighteen Microsoft

SQL Server 2000 with service pack 4.

Currently, all the sql 2000 recovery model was set to Simple. It was setup and maintenance by the developer teams.

I am planning to develop a database DR high level plan.

How to develop the baseline?

Please help and advise.

Thanks,

Edwin

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

Gail,

I have to say that I'm very impressed by your post and articles. You add a lot to the forum.

Thank you,

Welsh

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Edwin-376531 (2/11/2010)
I am planning to develop a database DR high level plan.
How to develop the baseline?

That's a very complex question and not one that we can answer form you. You need to find out the data loss and down time allowances for these apps, the budget that's available for Disaster Recovery/High Availability, and then design a strategy that allows you to meet those requirements.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass