Thanks for reply--

Group by function - need to specify for all select column..

Hi Mazzz,

Thanks for your reply and also provide Mr. Paul written by valuable script for analysis different wait stats on SQL server 2008.

As per this script

ASYNC_NETWORK_IO

ASYNC_IO_COMPLETION

BACKUPBUFFER

Those counters display...

Thanks LutzM for reply...

Yes, this is SQL server 2000. I will find the script for missing index in sql 2000.

Could you please share me this missing index script on...

Thank you John for reply...

use msdb

select top 10 *

from msdb..sysmail_send_retries

where send_attempts> 1

order by last_send_attempt_date desc

select top 10 *

from msdb..sysmail_send_retries

order by last_send_attempt_date desc

Both script no rows are comming, after sending test...

Sorry for the improper question?

I want receive alert regarding whenever SQL server Error and agent error occouring in error log file, that time will received email alert from SQL server...

Database size 340 GB.

Backup file has been storing tape as well as secondary server. If any corrupted in primary server, i restore from tape but its takes too long time,...

Thanks Ashish

I have to wait for completion current executing restore process till received message, now 5:70 mint, I think its takes more than 8 hrs.

Rgds

ananda

Thanks for reply...

If Kill it operation, again i have wait too long time for restoration, current restoring process with no recovery, is it display any message for completing restore process....

Hi,

How can detach and xcopy .mdf and Ldf file as you said, this server is production and live server. there is no downtime

If copy those files minimum 8 hrs...

Thanks Gail for reply..

There some possibilites do that

1. Add more space in server - asking serveradmin team for increasing more free space.

2. Management not accept do delete the old data...

Database Size is - 5406 MB

Database free size - 1314 MB

I created new alert thru

Set the type as SQL server performance condition alert.

Choose SQL server: DATABASEs from OBJECT drop down...

Thanks GilaMonster for reply

sp_spaceused, its outcomes below

Database name -BRIBS

Database_size - 330072.75 MB

Unallocated Sapce - 22.71 MB

Reserved - 337968424 KB

data - 337237296 KB

Index_size 314768 KB

unused 416360 KB

here attached xls sheet for...

Thanks for reply..

Please tell me one more suggestion as following task can be configure after upgraded to SQL 2008 method of IN-Place.

1. Replication

2. Mirroring

3. Logshipping

---------------------------

email Alert

Demo Alerts for SQL Server...

hi

Here are some of the ways of move the database

In-place Upgrade

Side by Side Upgrade

Detach/Attach

Copy Database Wizard

Manual Schema Rebuild and Data Export/Import

Choosing upgrade method

The two...

Thanks for reply...

I don't want restart again that "BkupExec" Instance.

I don't know what is use of that instance, already running local instance in production database. so i want to uninstall...