Sounds like the read only file system property is set to true on one of the files you are trying to attach.

Backup restore is usually the preferred method.

For larger DB's I use logshipping which takes a small amount of preparation but can be setup well in advance of any DB moves

Orphaned...

Only if you are running a detailed trace.

In most environments capturing every script/query is a massive overhead simple because of the TPS.

The only way you "could" get the data on...

I use a combination of PowerShell and SQL PSX

$Instance = 'ServerName'

$scriptargs = [Microsoft.SqlServer.Replication.scriptoptions]::Creation `

...

Based on the...

Internal value that indicates the perceived load on this scheduler. This value is used to determine whether a new task should be put on this scheduler or another scheduler. This...

Its worth pointing out that if there are more transactions to be delivered they will be delivered up to the maximum batchsize/commands setting on the distribution agent. If any...

Megistal (10/12/2012)

---

This is what I've found so far:

http://msdn.microsoft.com/en-us/library/ms151762%28v=sql.105%29.aspx

By default, transactional replication propagates changes according to transaction boundaries. If transactions are smaller, it is less likely that the Distribution Agent will...

chandan_jha18 (10/12/2012)

---

I agree with MysteryJimbo that if the procedure has been caught doing nasty things time to time, we may add recompile option on the procedure level rather than running...

It is highly unusual.

Does the proc in question gradually decrease in performance? Does it improve when recompiled?

If it is a single procedure why not add the RECOMPILE option to the...

Or if you need 4 different jobs to run concurrently, you can add a fifth job with a TSQL job step and use

exec sp_start_job 'job1'

exec sp_start_job 'job2'

exec sp_start_job 'job3'

exec...

baabhu (10/11/2012)

---

MysteryJimbo (10/10/2012)

---

I'd do each step in order as a precaution.

Are you managing your transaction log with regular backups? If so, why do you say the log file is...

I'd do each step in order as a precaution.

Are you managing your transaction log with regular backups? If so, why do you say the log file is going to...

You can add another log file to the new drive and set the old log to not grow.

You can then

Then remove the...