Would you please share with me how to backup to separate, individual bak & trn files.

I only know to accomplish those by setup separate jobs.

Thanks,

Edwin

You should use SSIS to transfer your data from SQL 2008 to SQL 2000.

When I tested the scripts on SQL Server 2008 SP1, it runs into problems:

Msg 102, Level 15, State 1, Line 7

Incorrect syntax near '?'.

Msg 137, Level 15, State 2, Line...

Hi Steve and all,

I 'm very appreciated your help and advice.

Best regards,

Edwin

Hi Steve,

I run DBCC SHOWCONTIG ('dbo.FaultTables')

GO

Results:

--- Scan Density 81.31%

--- Logical Fragmentation 1.56%

--- Extent Scan Fragmentation 34.82%

--- Avg. Bytes Free per...

Both the Publisher (Microsoft SQL Server 2000 SP4) and Subscriber (Microsoft SQL Server 2008 SP1)

have the same collation = SQL Latin1_General_CP1_CI_AS.

Can the collation issues cause replication error?

I have over 100 GB database size that transfer over T1 line bandwidth.

Can you give me some light on how long it will take?

How to calculate?

Roy,

I saw some activities on Replication Monitor that showed Distributor to Subscriber History tab

such as:

--- Table A 100000 row(s) copied Total 12800000

--- Bulk copying data into table A

--- Bulk copied...

I tried to digest you all discussion and a little heavy for me 🙂

Hi Toby,

Many thanks for your kind advice and help.

It is working now after I executed:

GRANT CONNECT TO [DomainName\User Name]

Go

Questions:

What is the best practice to create SQL Login utilized Active Directory?

Best...

Hi Gail,

Thanks for the Managing Transaction Logs article and it was very helpful.

I reported a new IT manager and be asked to provide DR plan on eighteen Microsoft

SQL Server...

Can you explain in detail?

In addition, should the sql database recover model set to Full?

So, I can back up the transaction logs?

If the database setup full recover model,...

Hi Welsh,

I did perform the step #2 that you mentioned on the discuss

SELECT TOP 10 * FROM Table_A

ORDER BY ROW_1 DESC

Questions and Discussion:

The SQL 2000 database was setup with...

I figured out the problems. It was the port that I specified on TCP/IP.

Somehow VMWare (I suspected) did not allow the sql named instances to use the...

Hi Noel,

I run into same issues.

You mentioned “Make sure that you can cleanup the db from any replication settings”

Can you explain in details please?

Thanks,

Edwin