charipg (4/17/2012)

---

we were unable to start SQL Server.we found that corruption with C++ Distributable libraries which cause SQL Server2005 not to start.

Then we reinstalled C++ libraries , 2005 SP1 version....

😉

When configured correctly it works well. Can you supply more detail on the set up you have, mutli path, etc?

For an idea of getting things setup see my popular guide...

Junior DBA.M (4/17/2012)

---

Hi

I would like to set up a daily job that backs up the database and transfers a copy of the backup on to a disk on a different...

opc.three (4/16/2012)

---

..good thing Perry jumped in with the goods. I was definitely headed down the wrong path with cached tickets and the user you were running stuff as. I am...

winston Smith (4/16/2012)

---

Perry, you have made my day!

Just remoted in and gave this a try and it worked! I spent 3 hours looking at this before leaving it for...

winston Smith (4/16/2012)

---

I ran setspn -l server.domain and got a list of all SPN's for the server.

I then ran setspn -d MSSQLSvc/server.domain domain\serviceAccount to remove the MSSqlServer SPN.

I then ran...

Firstly, check my guide at this[/url] link for information on creating and using mount points in a cluster.

So, the steps required are as follows;

1/ deploy new windows server using exactly...

Why 1000MB, 1GB = 1024MB?

balasach82 (4/16/2012)

---

tempdb data is currently at default 8mb, which will be increased to 1gb.........

.................ALTER DATABASE tempdb

ADD FILE (NAME = tempdev2, SIZE = 200, FILENAME = 'D:\\...\tempdb2.mdf');

GO

.................

......................one LDF file

Do...

Cool, no problem.

Like I said though, in my experience i'm dealing with an instance of SQL Server where i am not only adding files but also reconfiguring the primary file,...

Are the objects in a separate schema, i.e. not dbo?

balasach82 (4/15/2012)

---

Perry/Gail,

I had settled for Gail's view that SQL restart is not required after tempdb division. Perry recommends a restart for the algorithm (for which the tempdb is being divided)...

Are you sure you set the correct database focus for the query window, you didn't run it in...