Search Results | SQL Server Performance Forums

SQL Upgrade to 2005

Thread by: arisdxb, Jan 22, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I am planning to upgrade my SQL 2000 server to SQL 2005. The SQL server 2000 is installed on clustering (Active/Passive) environment and the...

SQL Database synchronize

Post by: arisdxb, Oct 11, 2006 in forum: General DBA Questions

Thanks Brad and Dineshasanka for your valuable suggestions. Aris

SQL Database synchronize

Thread by: arisdxb, Oct 10, 2006, 4 replies, in forum: General DBA Questions

Hi I have come across a strange scenario in my company that we have a production database and my manager needs to get a latest copy of that...

Restore db that set for transactional replication

Post by: arisdxb, Apr 21, 2006 in forum: General DBA Questions

Thanks for your all valuable response.

Restore db that set for transactional replication

Post by: arisdxb, Apr 18, 2006 in forum: General DBA Questions

Thank you Satya, I haven't set sync with backup option and the log reader was failed to process. I hope there is not inconsistencies in my database...

Restore db that set for transactional replication

Post by: arisdxb, Apr 16, 2006 in forum: General DBA Questions

Thanks Nathan, I have run the the sp_replrestart stored procedure and it worked with out error. But as per book online it says This method can lead...

Restore db that set for transactional replication

Thread by: arisdxb, Apr 16, 2006, 7 replies, in forum: General DBA Questions

Hi I have setup transactional replication on my production database and it was working fine. My database was corrupted due to some personal errors...

Query to find idle time from a table

Post by: arisdxb, Nov 21, 2005 in forum: T-SQL Performance Tuning for Developers

Thank you very much. I will try the TSQL and I will reffer the book too

Query to find idle time from a table

Thread by: arisdxb, Nov 19, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi All, I have a table with fields ID (identity), Start(Start Time) End(End Time) and data as below. ID Start End...

Adding one more subscriber

Post by: arisdxb, Oct 29, 2005 in forum: Performance Tuning for SQL Server Replication

Thanks But the replication is already running and I want add one more subscriber to it. Do I need to create initial snapshot again for new...

Adding one more subscriber

Thread by: arisdxb, Oct 29, 2005, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hi All I have a transactional replication with one publisher/distributor and one subscriber. I want to add one more subscriber for another location....

Distribution database role

Thread by: arisdxb, Oct 18, 2005, 1 replies, in forum: Performance Tuning for SQL Server Replication

Hi I have some doubt about the role of distribution data base that whether distribution database hold the new transaction or just pointing it to...

Any problem to restart SQL server on cluster?

Post by: arisdxb, Oct 12, 2005 in forum: SQL Server Clustering

Thank you very much for your reply, Actually I was little bit confused about offline and online. Offline/Online = stop/start

Any problem to restart SQL server on cluster?

Post by: arisdxb, Oct 11, 2005 in forum: SQL Server Clustering

Thanks, I don't know how to restart SQL service via cluster administrator. Please help. Aris

Any problem to restart SQL server on cluster?

Thread by: arisdxb, Oct 8, 2005, 6 replies, in forum: SQL Server Clustering

Hi All I have SQL server installed on cluster (Active/Passive). I would like to restart SQL service on active server. Is there any problem to do so?...

Any problem to restart SQL server on cluster?

Thread by: arisdxb, Oct 8, 2005, 1 replies, in forum: Contribute Your Performance and Clustering Tips

Hi All I have SQL server installed on cluster (Active/Passive). I would like to restart SQL service on active server. Is there any problem to do so?...

DB file growth

Post by: arisdxb, Oct 3, 2005 in forum: Performance Tuning for DBAs

The recovery model is Full and I am worried about transaction log size. After taking the log backup I belive that log size should shrink but my mdf...

DB file growth

Post by: arisdxb, Oct 2, 2005 in forum: Performance Tuning for DBAs

Thanks for your reply. I have run all DBCC Command and got no error. The followings are the results. ------------------------------------ CHECKDB...

DB file growth

Thread by: arisdxb, Oct 1, 2005, 11 replies, in forum: Performance Tuning for DBAs

I have a database for Great plain ERP and it grows unexpectedly. The database is replicating to the H/O server with transactional replication model....