Hi,

log_reuse_wait_desc detemines or givesDescription of reuse of transaction log space is currently waiting on one of the following:

NOTHING

CHECKPOINT

LOG_BACKUP

Note:

If the reason is LOG_BACKUP, it may take two backups...

Hi,

Stored below code in .VBS file & run file

You can change parameter (Disk.FreeSpace/Disk.Size) < 0.30 in script

Set DiskSet = GetObject("winmgmts:{impersonationLevel=impersonate}").ExecQuery("select FreeSpace,Size,Name from Win32_LogicalDisk where DriveType=3")

for each Disk in...

Hi,

MSSQLSERVER & SQL Server Agent both main services were created after installation of database engine. for more info refer book online....

Rd,

Deepali

Try Below Query..

sp_msforeachdb @command1= "select '?' as Databasename EXEC ?.dbo.sp_helprolemember db_owner"

Rd,

Deepali

Hi,

To resolve the problem backup your database;

Backup log database with truncate_only

this will truncate the non active logs from your log file then try to shrink your database Log...

This problem is due to printing a report generated by SQL Server Reporting Services directly from the browser requires a control names RSClientPrint.

SQL Server Reporting Services has this control in...

Hi Gift ,

Thanks alot for your reply.

Regards,

Deepali

Thanks a lot, Michael.

After executing sp_who2,

one of my system process shows status like this,

spid:9 status:SUSPENDED sa master CHECKPOINT...