Search results for query: *

I mean the baseline features should be for performance monitor and not available in SQL Profiler which is used to trace problems, thanks

Thanks a lot, catadmin Do you really mean performance monitor, I heard that before but I don't know how to create a pmon baseline and how to compare it with the current performance numbers, can you tell me how to do that in a little detail?

Thanks, I mean user defined function, somebody defined functions for calculate the value for a cell, I can't find the defination.

How can I find the defination for a spreadsheet function? Thanks

We have a database that increase the size continuously, the database is updated every early morning by batch updating SQL, then keeps still in the day time. The only scheduled maintenance job is shrink the database to 50M free space, and the SQL Server is always running and never supposed to be...

I want automate the recovery test for our databases, I have a test server which is for all the SQL servers in our company, I can write code to run the restore command with backup files in correct sequence for each database, the problem is I don't know how to write the verification code, I need...

I need to be aware of the grownth speed, then I can avoid the backup failure. Can I use this command to estimate the grownth speed of the database?

Thanks for all the help, Catadmin, If one of these servers hasn't enough space for the coming backup, I should be able to get warning, do you have any ideas on this issue?

Following is my answer: 1. I have the sysadmin permission 2. This is SQL server 2000 enterprise edition 3. This happens with only one user database 4. Yes, it's in option tab of database properties

So it really need to run at a low traffic time?

I run dbcc checkdb on one of SQL Servers from my work station, it takes a while then give me an error like network error, the connection broken. I ran it again in the same time I monitor the server using performance monitor, the disk time jumps fairly high when dbcc checkdb is executing, I'm...

No, I mean the OK button supposed to be enabled when the user makes any change, but it seems that changing the recovery mode won't enable the OK button.

The problem is that when you open the dialogue, the OK button will be gray, when you change any setting other than change the recovery mode by selecting one of option from combo box, the ok button is enabled, but change the recovery mode won't make this button enabled, it's like a SQL Server bug...

Thanks for all these good advice, thinking of every SQL Server instance may have different backup jobs, to monitor these jobs and automatically test the backups will be a pain, I don't have a plan yet.

I took the SQL server DBA responsibility in our company, I have more than 10 SQL servers or even more to administer in the future, how can I administer them centrally? use EM? Any tips for centrally administering many SQL server instances? Thanks

This is a interesting topic, I want know a little bit more. Some third party backup tools actually has features like SQl server database backup, it sounds like the backup is taken from the database rather than a filesystem file copy. This may raise issues when there are also SQL Server...

I looked one of our SQL server database in enterprise Manager, open the database properties dialogue, the OK button is disabled, I have the sysadmin role of the SQL Server, how can this happen? thanks

Thanks a lot Bill, that really helps.

Has anybody ever used the third party backup tool NetBackup? Does it affect the SQL server backup jobs? Thanks

Using robocopy I can only remove the backup files to a directory and then delete it, is it possible to do this in one step that delete the older files and don't move it? That may save some I/O on the machine. Thanks