For SQL Server 2005, is there any query or something to find out the Total Virtual memory & Used Virtual memory?

For above SQL Server 2005, I know that we...

Hi,

I also have the same doubt. Physical table is around 2 GB and the buffer size is 5 GB. I couldn't able to corelate it.

Hope someone responds to...

Thanks a lot for your replies.

Jake,

The reason why DiskKeeper will not work for us because we have SQLServer backups on the same disk where data & log files are...

The problem with our server is we have database files and backup files in the same disk. As backups (70 GB after compression with litespeed) are created and deleted, it...

Yes. It is a transaction log file but the problem is not only with the log file but also with data files. I shrunk the log file on the primary...

Oh!.. my god .. I'm DEAD ... So, till we add extra storage to DR server, logshipping will be out of sync... I don't know what is going to happen...

I think unless he is trying to restore logs we don't have to worry about truncate or recovery model.

He is trying to restore differential backup and there could be...

I think your problem can be solved if you try as per below article.

You should declare qResult as string.

http://support.microsoft.com/kb/279514

I had been trying the same script from DTS packages....

If you are trying this from your office then probably this error could be because of Mail Exchange Server. System Administrators will stop relays in the Exchange server to prevent...