dsohal (8/6/2010)

---

I get this info,

dbo. sysssispackages # of records = 20 Data 9544 KB

dbo.sysmail_attachments # of records = 18 Data 4064 KB

dbo.sysjobhistory # of records = 1000 Data = 2184

These...

Even I think so 😉

If your question is how the backup job is successful without a BACKUP DATABASE command in it, here is the asnwer.

In SQL Server when a Maintenance is created as an...

1) On each linked server I have ticked the option 'For a login not defined in the list above, connections will...Be made using the login's current security context'

...

At the time of restore some other application (like antivirus) tried accessing this file and it is pending recovery.

Can you try RESTORE DATABASE databasename WITH RECOVERY?

This article explains how to insert value into an Identity Column.

You should have posted this question in SQL7,2000 forum. However, check if the setup log file has any information. It is C:\Windows\sqlstp.log

The database size will increase when you are rebuilding the index.

Reindexing and Shrinking is a very bad idea. When you shrink the database the indexes will be fragmented, which defeats...

Microsoft documents this error as

This can happen if a sockets client (which includes SPX) aborts the connection. This error is usually seen in conjunction with error 17824 when on sockets-based...

What is the status of replication after this error? If the queue reader agent has been running fine ever since, I don't see any issues with this.

First of all why would you try all this in an Cluster Environment (Assuming it is in production).

To resize the data file to less than the currently allocated space, you...

Please check if SQLAGENT.OUT file has any error messages at the time of this error. If the SQLAGENT.OUT file does not have entries during that time frame, I feel Agent...

Resource database cannot be moved. You cannot change the location of that database using SSMS since it is not listed there. Please refer this article on how to move System...

Please refer this link for getting started.

If you already have Database Mail configured, please check the properties of the same. It will contain the SMTP server details.