We have a problem with database restoration.
We need to restore broken database (after power failure).
We are using Data Protector to...
We are looking for solution to replace standard SQL Replication to something better.
We are replicating data from many remote locations to our...
OK so why the same query works fine on another server?
Now this... I've added to query OPTION (LOOP JOIN) and everything works. Why with merge join...
As I said that was only example. My query is more complicated but I wan't to show only the problem.
The same query (on another server ) is working...
Please help :)
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...
1. As I know there is no need to backup transaction log on database in SIMPLE mode.
2. This database is used as application log (true is that...
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...
They have SP3A on main server (publisher) and SP4 on other 14 servers (subscribers).
There is no AV process on the server.
I think that you should check Log Shipping or replication as solution.
If you are using SQL Accounts in your databases (on production server) then...
Sorry for long delay with answer.
SP_WHO2 - I don't have any SP_WHO2 history log. I will make copy QA results next time.
Scheduled jobs - there are...
I have a problem with SQL 2000 Ent. 64bit. This problem occurres in random situations (1-2 times per week).
1. "Time-out" on users...
Ok but this server acts as publisher and subscriber.
He has 4 published databases and 2 databases are subscribed form other servers.
So I need only...
Thanks, I will generate scripts for replication and change @sync_type (as you write). If it works I will be very happy :)
One think more. If...
Can you tell me more about restarting replication. What should I do? Script replication is enough or I need to do some manual job?
What do you think about this problem?
1. Server and system databases (including distribution database) are in bad collation format.
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?...
OK but are this negative values "saying" that something is wrong?
Can this stop database for growing?
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...
What is gone happened when system needs memory and I've setup dynamical memory allocation and reserve phisical memory?
Separate names with a comma.