joshua.post (6/6/2013)

---

Is backing up the databases and restoring the best way, including Master and Model, or once the old server is shut down, can I just copy the files over?...

joshua.post (6/5/2013)

---

We have a SQL 2005 Standard cluster with 2 nodes on Server 2003 R2 Enterprise. There are two SQL instances and two File Server resources on this cluster....

As you say, "these accounts". For any account that is not specifically the SA account, can you reduce the permissions to simple read/write? What essential feature do the applications have...

Thanks again, Gail.

I've enjoyed working with a new partner who has been helping me move from my old strategy to one based on the Ola Hollengren routines. He's confirmed that...

John, Gail -

Put simply, "I hadn't thought of that". Thanks for the input.

Without intending to hijack the thread, there are several other considerations involved:

1) I'm at a regional...

Using the weekly scenario that was mentioned, it will help your sanity if...

1) Schedule the Weekly Full backup (i.e. Sun) and the Daily Differential (M-F or M-Sa) at...

ganci.mark (5/1/2013)

---

Thanks OPC.

From the link I found this:

For SQL Server 2005:

SQL Server Version Range

9.0.5000-9.0.5068

SQL Server Update

SQL Server 2005 Service Pack 4 GDR

(KB2716429)

SQL Server Version Range

9.0.5200-9.0.5323...

This "frozen and thawed" backup issue caused me many headaches over the years. Both ArcServe and Symantec Backup Exec were the culprits, on different machines. It effectively broke the backup...

I can't help myself - I have to ask:

Maybe it could be a lower-case "L" ("l") instead of an Upper-case "I" ?

Robert klimes (9/11/2012)

---

if you haven't found an answer yet may this will work.(http://blogs.msdn.com/b/karthick_pk/archive/2012/07/16/the-process-cannot-access-the-file-c-windows-system32-perf-mssql10-50-mssqlserver-sqlagtctr-dll-because-it-is-being-used-by-another-process.aspx)

I have had the same issues with CU2 for SQL Server 2008 R2 SP2. Haven't test the...

Interesting one, but his explanation is specific to clusters. Mine has come up with the same error on clusters and single-node...

weberharter (5/18/2012)

---

hi there,

i don't know what information you want...

"Extended support" means you can buy assistance with "incidents". However as I understand it, there will be no more service packs or cumulative updates.

Sorry, I don't have anything to do with it, other than being a satisfied user. 🙂

Steve's done fine (he was my backup). Microsoft is the one that has dropped the ball.