You need to clarify what you mean. Your posts doesn't quite make sense. Do you mean a full database backup of the primary restored to the secondary?

If the timeouts are...

Can you also give us the memory settings and what is stable RAM And what is the level it increases to?

Any XPs installed as well?

The links should be fixed and my apologies to everyone. We've tightened security and I forgot .sql scripts will not download. They are renamed to .txt.

Joseph,

Good points, but the reality with RAID 1+0 isn't that you can lose half the drives. You may be able to, but not necessarily.

If you have drives 1, 2, 3...

Ask and yee shall receive:

http://www.sqlservercentral.com/forums/messages.aspx?forumid=384

I thought 431 was hard because it covered a wide variety of topics. For me the questions in some areas took some guessing, since I wasn't sure. The sims were...

There's a SQL 2000 DTS Runtime you can install on 2005 to run your packages.

The advice above looks pretty good to me as well.

It's deleting the parent record and having the child records deleted too. No perf penalty I'm aware of, but it's automatic, which means that it happens and you can lose...

SQL 7 and 2000 had some great benchmarks on SAP. They used to be some of the biggest MS testing customers.

Daniel

For your DB, I think you want to look at...

You need these to be sure you don't have mislinked or cross linked page or corruption. If you catch them early, you shouldn't lose data. They don't happen much, but...

Does the Update Stats job fail ever?

I agree that something strange is happening. How are you transferring the dbs?

This is a separate server, right? Any restarts on it during the...

Viraj,

It was a good question, so I started to list some differences. Look for an article soon on this topic.

Steve

Data backups and log backups are differnet. IF you are in full or bulk logged recovery mode, you need to be sure you back up the log as well as...

I believe you can use images, though I've never tried.

The only way you can insert two tables with bulk insert or bcp is to already build the IDs in both...

Keep in mind when you run it manually from your workstation, it runs from your workstation under the context of your account. As a job it runs under the SQL...