Viewing 8 posts - 16 through 23 (of 23 total)
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...
November 10, 2009 at 11:22 pm
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...
November 9, 2009 at 11:29 pm
Hi,
MSSQLSERVER & SQL Server Agent both main services were created after installation of database engine. for more info refer book online....
Rd,
Deepali
November 9, 2009 at 2:31 am
Try Below Query..
sp_msforeachdb @command1= "select '?' as Databasename EXEC ?.dbo.sp_helprolemember db_owner"
Rd,
Deepali
November 9, 2009 at 2:23 am
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...
November 7, 2009 at 12:26 am
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...
August 27, 2009 at 1:29 am
Hi Gift ,
Thanks alot for your reply.
Regards,
Deepali
March 5, 2009 at 11:03 pm
Thanks a lot, Michael.
After executing sp_who2,
one of my system process shows status like this,
spid:9 status:SUSPENDED sa master CHECKPOINT...
September 11, 2008 at 10:09 pm
Viewing 8 posts - 16 through 23 (of 23 total)