at what point do you get this error?

the syntax you want is

backup database dbname to disk = '\\servername\sharename'

or

backup database dbname to disk = '\\servername\drive$\full path to file'

+ whatever other clauses you are using

did this error occur when trying to restore a log backup? It just means someone or something is connected to the database and a restore needs exclusive use.

Make sure there...

might not be the answer you want to hear but with that many databases and more being created (by an app perhaps?) you should if possible be looking at a...

run dbcc updateusage

set compatibility level

set default schema for each user to DBO (if all objects were previously owned by dbo which is the usual case

drop the schemas created by the...

Marios Philippopoulos (11/11/2011)

But the odd thing is that after I run DBCC FREEPROCCACHE in dev and restore...

I'd compare query plans. Maybe the proc needs a recompile in prod.

if you write the log backups to a directory on the primary server you should then share that directory out and make sure the SQLagent service account for the secondary...

with 2008R2 you get compression anyway with the native backup so stick with that.

For earlier versions of SQL I like Hyperbac (now a redgate tool) as you dont have to...

wow......tough audience

Possibly memory pressure on the OS.

check out total memory usage of SQL (+ SSIS + SSRS) via perfmon counters. check out out paging and available memory as well.

Do you have...

Except for tempdb 'initial' size is meaningless once the database has been created.

What size is the data file, 50MB sounds quite small for the log, you don't want it needing...

there is no reset of the initial size, Just use the dbcc shrinkfile to set the log to the size you want it. It will stay that size unless it...

I trained as a dentist for a while but I couldn't live hand to mouth like that.

I worked as a geologist but wasn't down to earth enough.

I spent one spring...

initial set up of replication is manual, you would never be able to keep up with 50 databases a day.

You would also soon flood your network and have severe latency...