select session_id, transaction_isolation_level

from sys.dm_exec_sessions

where session_id = <your_SPID>

it will return numeric values.

0 = Unspecified

1 = ReadUncomitted

2 = ReadCommitted

3 = Repeatable

4 = Serializable

5 = Snapshot

Are your clustered indexes ever-increasing, narrow and unique ? If at least one "No", that might be a reson.

You are checking the total size, and it is different because files for these databases have some empty spaces. To check used space, you can use FILEPROPERTY(f.name, 'spaceused') for each...

You can also try partitioning.

If you partition by date/week/month, etc, and some older partitions are never updated, you can backup whole database once, and then only last, active partitions....

1. You can query sys.traces to make sure that default trace is running and to get path and file names.

2. select * from fn_trace_gettable (path_and_file, number_of_trace)

Thanks Lowel, I found. It's #15 in my case. But sp_who2 is too large for me, it returns close to 1000 recs. So I actually ran

select * from sys.sysprocesses

where lastwaittype...

Thanks a lot Lynn and Steve. Standby is what I needed. I did not know about that.

Yes, I have unique indexes on both sides, actually Primary Keys. I already fixed 2 errors of violation of PK by manually by deleting record from subscription.

About deletes, I...

It's not necessary to copy backup file from server to server. If your destination SQL server has access to source server, you can restore accross servers, by specifying "...from disk...

Hmm.. Good questions.

But it's very difficult to answer them. I just checked we have 137 tables and 189 indexes on subscriber side. We have more on publisher, but some...

Why do you need DBCC UPDATEUSAGE ? You are upgrading not from v. 2000.

How you will recompile all procs ?

You are upgrading in-place or move to another server ? If...

So what is your question ?

I suggest you to script out all indexes and drop them before data import. After it finishes, recreate from the script. It will improve you data loading performance, and it...

ACinKC (3/13/2013)

---

You didn't indicate where you are located, but if you don't report actual hours worked, you may be opening yourself, the consulting company you work for, and the client...

Steve-3_5_7_9 (3/12/2013)

---

Being that you are not a salaried employee, you cannot be expected to work for free. This is the sort of thing that should have been worked out...