Hi, We have a problem with database restoration. Situation: We need to restore broken database (after power failure). We are using Data Protector to...
Hi, We are looking for solution to replace standard SQL Replication to something better. We are replicating data from many remote locations to our...
Hi, I've got strange query results. I will write two statemets to understand where is my problem. My example (query) is only a sample but shows my...
Hi, I have a strange situation. On one of my databases I have a problem with log truncation. Database is in simple mode so this should work but it's...
Hi, I have a problem with SQL 2000 Ent. 64bit. This problem occurres in random situations (1-2 times per week). Situation: 1. "Time-out" on users...
Hi, What do you think about this problem? Situation: 1. Server and system databases (including distribution database) are in bad collation format. 2....
Hi, I need to rebuild master on 64bit edition server (to change default server collation). On 32bit it is easy but on 64bit I can't see rebuildm.exe?...
Hi, I see negative values on some database when I execute sp_spaceused. If I select database properties in EM I see that there i 0% free space on...
Hi, Can you explain to me about differences between memory options in SQL. I mean, better is to setup dynamic memory allocation or give SQL selected...
Hi, Are there any differences between FULL and SIMPLE recovery model in SQL performance? If database is in SIMPLE recovery model and there is a lot...
Is this article valid for SQL 2000? http://www.sql-server-performance.com/nb_avoid_bottlenecks.asp
Hi, One question. I've a problem with autgrow of one database. I see in log that server was unable to auto-grow file in ... seconds. Database was...
Hi, Is that possible that when server is making Log Backup or Full Backup of database users can not add data?
Hi, Can you tell me how can I change log file location (to new drive) when database is involved in replication? If I use detach I have to setup...
Hi, I've setup Log Shipping between two SQL 2000 Servers Ent. (64 bit editions). Almost everything works fine with one exception. I see that Log...
Hi, First, thanks for help with solution for Reporting server. Now I'm getting another problem. We have log backup every 2 hours on our production...
Hi,<br /><br />We need to set-up reporting server because our production server can't handle OLTP and reporting in the same time <img...
Hi, Is there any connection (looking for performance site) between LOG READER and Retension Period Time? I see that when I've change retension...
Hi, Can you tell me what is the correct way to remove one instance of SQL 2000 server on active/active cluster. I read that the best way is: 1. Use...
Hi, I'm looking for good solution in case when one of my replicated databases will be damaged. We have 16 servers replicating to main server....
Separate names with a comma.
