Thanks for this good article.

How can i made a restore test process and certify that my restoration is ok ? A sp_helpdb ?

I created a table named dbo.historique that contain the name of the databases.

Now, i need to create an error then the difference is <> '0' between the table dbo.historique...

It's a particular application in production that log the network information in a new database when the size is up to 5Go.

My issue is to know when these database...

Yes,

I think the sql agent can do that but the think is how to create the trigger or else in SQL 2000 to initiate the alarm on database creation...

How can i determine the reporting services or analysis services in this extract of my network ?

[font="Courier New"]ServerIP,TCPPort,ServerName,InstanceName,BaseVersion,SSNetlibVersion,TrueVersion,ServiceAccount,IsClustered,Details,DetectionMethod

10.15.104.31,1433,FRXTLTORX20,MSSQLSERVER,9.00.1399.06,9.0.1399,9.00.1399.06,CONSOTO\SRVS-SQL_TURBO,No,(UDP)ServerName;FRXTLTORX20;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.1399.06;tcp;1433;;(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER(SCM)Start_Mode: 2 AUTO_START ...

Thank you for this article,

I got a question about this : it's possible to scann either the Analysis Services and Reporting Services on the network with the same tool...

Yes we got a security team for this, but they do not know the port are needed to link a server between two SQL servers.

It seems that only 1433 TCP...

I'm using Veritas NetBackup too.

How to know that backup are reliable ?

Do you set up tests of automatic restore of severals databases to check them ?

Nice Article,

I wish to set up a solution as the one that you explain.

I am interested to see the code which you have create to inspire me on SQL Server.

Thx.

Nice article