Dear Members, Good Morning. We are having an issue in recent days in SQL Server 2005 while fetching data from drive. We are encountering the...
Dears, We have DB Engine Services in One Cluster say xx one VIP and Analysis Services in Another Cluster say yy another VIP. Can we have both ( DB...
Dear All. Good day to all. The question is not related to technology and it's a genaral Question about DBA designation levels in industry. I would...
Dear All. We have Production databases implemented with Replication process in place. At present we are planning to move the log files from one drive...
Dear All. I have Configured the Replication process for our Production Database Servers , and the transactional log is increasing. Here i am...
Dear Team. we have one production Database Server with SQL 2000 with SP4. in that we have more than 100 DTS Packages and we are working on that on...
Dear Team. I have a doubt while implementing the Replication concept in Production environment. Actually we have three Database server for...
Dear All. I have my environment with SQL 2005 Databases and those Databases are configured with LogShipping Configuration.here i want to clarify one...
Hi team. As part of the Database backup maitainance Plans in SQL Server 2000 we can able to select delete files older than --days.but i would like...
Dear Team. As part of the Database maintenance plan we are taking the Backups in Server on daialy basis whether full backup /transactional...
Hi team. I have one SQL Server 2000 database instance. in that some one has chenged the sa password.i would like to know who has changed password for...
Dear All, I have two instances in my Database Server with Microsoft SQL Server Standard Edition (64-bit) versions and i have 32 GB RAM in the same...
Hi all, Actaull i have Database level triggers in my Database.i want to restrict access to particulars users in the database.but the particular user...
Hi All, I have Database with 500 tables intially, now i have separated 500 tables in to two different databases.these two databases has been...
HI All, Here i am planing to ask one security related issue in SQL Server 2005: I have created one Login id with dbo permissions. After few days the...
Hi, i have around 500 tables in my database with size of 20 GB. Now i am planing to remove 200 tables from the database. after deleting the database...
Hi , One of the database in our SQL Server 2000 environment is in the suspect status. We need to bring it back to the normal status. The problem...
Hi all, Here I am facing one issue in Log Shipping server: I have configured the Log Shipping in my production server and those databases are in...
hi all, When does a SPID status change to 'Sleeping' and what does that indicate? I'm assuming that after so many seconds or minutes have passed...
hi all, i am facing some server level issue one of our Database Production server. Actually we have 16 GB RAM with 4 processors for database server....
Separate names with a comma.
