Viewing 15 posts - 16 through 30 (of 45 total)
Hi Thanks for updates
Gail please let me know these (integrity checks and index maintenance)tasks before or after Backups.?
And for DB maintenance what else can be done for Production
December 3, 2012 at 2:17 am
Only Full & Trn Backup
December 3, 2012 at 12:13 am
Hi no one replied till
Please UPDATE THE SOLUTION
October 18, 2012 at 5:39 am
Thanks for the reply
I added Integrity check before backup task in the Maintenance plan
But Job/MP is failing as per the scheduled
October 8, 2012 at 4:34 am
Hi,
In one of our servers(sqlserver 2005 ent edi) all maintenance plans(scheduled db backups) running under sa login & pwd
we have changed the sa password
now all maintenance jobs are...
September 24, 2012 at 3:46 am
Hi thanks for the reply
below is exact errror
DESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication Distribution Subsystem: agent . The subscription(s) have been marked inactive and must be reinitialized....
January 26, 2012 at 10:57 pm
Hi Gail Shaw,
Thanks a lot ,Thanks a lot ,Thanks a lot
I will work on this.
Thanks a lot again for quick reply
December 14, 2011 at 2:44 am
Hi,
DEV team will provide the script to DBA deploy in Production .
December 14, 2011 at 12:45 am
Hi,
Thanks for the Reply
My requirement As A DBA i need to capture back end correction(done by DEV team) audit log report to send my Manager
December 14, 2011 at 12:17 am
Hi,
Please let me know good maintenance plan for Production Database size >5GB
Any proper order like (rebuild index ,update statistics and database integrity etc...) Every weekend or Daily
Thanks in advance
December 14, 2011 at 12:07 am
Hi,
Our requirement is
when ever any backend correction or applying patches(scripts) done @production SQlserver 2005 by our user (Ex : changes in objects(tables,proc,func,views,...)
how do i capture the auditlog...
December 13, 2011 at 11:56 pm
December 6, 2011 at 10:06 pm
Got the solution from google
Deleting Files
Deleting a data or a transaction log file removes the file from the database. However, you cannot remove a file from a database if...
October 7, 2011 at 4:13 am
Viewing 15 posts - 16 through 30 (of 45 total)