You said you restored the database back to the same server as the original and...

balasach82 (4/14/2012)

---

I do have SQL 2005. Plan is to divide tempdb into multiple files. I had some doubts,

1. After dividing the tempdb into "n" number of files, do we need...

cc 49739 (4/15/2012)

---

OK, back from Googling betwixt wallpapering. Would I be correct in thinking that I am unable to do this with 2005 express (which is what I am using)...

You moved a copy of the database, what did you do about the logins that access the database did you transfer these too?

Open a new query window against the newly...

The size of he database has absolutely...

Send me your email address and I'll send you my guide

Hbruce (4/14/2012)

---

I need advice on what is the best method to use. I recently purchased 2 new servers with 2008r2 server enterprise and SQL 2008 r2 enterprise. I need configure...

Why aren't you using .net roles and authorisation it has all you need for this

Log shipping would work, you just need to make sure that the administrator at the time of any failure is well versed at bringing SQL server databases online and general...

Way too much for us to make a sensible recommendation.

KTG (4/13/2012)

---

the cluster distributed work, while everything has to be funnelled to a...

praspras42 (4/13/2012)

---

No I mean sorry that i was not specific

I just want to know that can i write a

procedure with the help of which i can take the

backup of...

ha haaaaa, bollywood comes to SSC 😀

I never see a need to dedicate a whole drive\volume to what are essentially little used and extremely small...

Can you detail the exact steps you are taking and the options you are using to create the linked server?

Firstly, use the catalog...