Thanks Satya for your help
Do I need to grant execute permissions on xp_sqlmaint in master DB to this a/c?
Hi fellow DBAs, In a bit to increase security, I recently removed the built-in admin a/c in sql server. Before that, I created a new SQL Server a/c...
1. Perform the weekly purge (deleting approximately 500,000 records). 2. Shrink the datafile "dbcc shrinkfile ( filename, TRUNCATEONLY)" What I...
Thanks Ravi.
This is an educated guess. I believe SQL Server reports space used based on the HWM (High Water Mark) which basically is the location of the last...
Thanks guys.
The listening TCP port for Oracle is 1521, for Sybase is 4200. Any idea what is the TCP port for SQL Server?
Rather than sp_detach_db when the trans log file is full, isn't it better to 'backup log with no_truncate', followed by 'backup log with...
Tested & proven. If I've a valid backup of DB & trans log files, there is no need to sp_detach_db, renaming .mdf files etc as 'restore database...
Hi MeanOldDBA, Seen those posts already. I suspect that the reason those dba are performing sp_detach_db, renaming .mdf files, modifying systables...
Hi, Got a recovery question here. If my user db transaction device file is deleted, but my user db data device file is intact, a) How do i perform...
Separate names with a comma.
