Then you should start off with the 4 files, baseline performance, then add the 4 new files and check peformance again.

Are all these files in the same filegroup? How do...

only logically, via SSIS or script out and BCP. restore ar attach won't work.

Linda Johanning (2/11/2009)

---

Have you capped the SQL Server memory? If so, try different amounts--maybe 2816 or 3072. Did you stop / start SQL Server? (Don't remember if...

don't get this at all. I answered 1,4,5,7,8 and was amazed to get it wrong, so I have checked it using QA in 2000 SP4 and SSMS 2005 SP2, both...

no probs.

'Virtual DEVICE' suggests a third party backup tool which does hot backups of the databases directly off the server. Is such a tool installed as part of your standard build?

These...

you have taken a new full backup of the primary, yes?

copy that to the secondary,

the database now already exists on the secondary so when you restore over it you have...

once you bring the secondary on-line you can apply no further tran logs to it, the db needs to be in recovery or standby mode.

Only one way -backup primary...

out of curiosity, why so many files?

thats good to hear. thanks for the feedback.

a value of 0 for AWE setting does mean it is disabled.

check this in query analyser with command: (run one line at a time)

exec sp_configure 'advanced options',1

reconfigure

exec sp_configure 'AWE'

exec sp_configure...

yes basically

don't have to be shares but...

the /3GB switch...

see http://msdn.microsoft.com/en-us/library/ms188698.aspx

for the initial restore with norecovery of the full backup, do that step manually, results are not good if you leave that to the logshipping GUI. then take it...

I'd have to disagree with that. The no of locks is a dynamic setting, if SQL requires more , it takes them, as each lock uses a bit of memory,...