so that means I can use both compression and non-compression backup files in one restore process together for a database, correct?

Thanks,

I am interested in that too, we...

Grant Fritchey (4/5/2013)

---

Looking at os_wait_stats is looking at waits aggregated. There's no way to know if those waits correspond to problems during your restore. That's why I suggested looking at...

Any help please?

I did a query like this:

--see the top ten events your server is waiting on

SELECT TOP 10

wait_type ,

...

Thanks much!

Using delete will also create big transaction log data. The tables we are working on have huge records. So using delete is not a good choice for us.

If I use drop FK,truncate table, import data, then add FKs,

Then I don't need to figure out the order of the tables.

Lowell (4/2/2013)

---

i would consider disabling and re-enabling them instead; either way it's effectively the same thing:

select

'ALTER TABLE '

+ QUOTENAME(schema_name(schema_id))

+ '.'

+ quotename(name)

+ ' NOCHECK CONSTRAINT ALL'...

Sean Lange (4/2/2013)

---

If your data is violating your FK constraints, which from the sounds of your post it is, dropping the constraints to import the data isn't going to help....

Thanks, my question is...

I found it runs much faster using...

Sorry, it works now.

I found out the path for the file is wrong.

Thanks much

MyDoggieJessie (3/28/2013)

---

If you haven't specified it during the initial install, it's set to 0 by default, meaning that it happens automatically (running approximately every 1 minutes for active DB's)

Reference MSDN...

GilaMonster (3/28/2013)

---

Checkpoint runs...