For the moment, add the service account you are using to the windows local administrators group of your server.

Maybe best to stop / start your sqlinstance.

Then you should be able...

Chris,

I just hope people don't get scared to start small, if you hit them with "armagedon" :hehe:

Don't present a dam breakage scenario for those that need to seal up a...

check you sqlserver instance ERRORLOG file to see if the startup is OK.

You may also want to try to add your windows account to the local server group called

computername\SQLServer2005MSSQLUser$computername$instance

In my...

Oh indeed....

One of our devs was astonished his server didn't work after a 380V overload (it should be 220V and due to an electrical mishap the cerquit got an overload...

You only know what your insurence pollicy is worth, the first time you need to call for its couverage !

In case of sqlserver, you can challange your DRP before you...

this is on sql2005, right ?

Check the OVER clause in BOL. It may provide you a nice solution for your problem.

from BOL:

The following example shows using the OVER clause with...

It must have been the magnifying glass that did the trick 😀

Do you mind sharing the solution you came up with ?

In this case it is relevant !

A...

Indeed, you still need to prepare these actions;

In best cercumstances, you would collect performance data (trace), analyse it, and check your results with the dev.team.

... we're already in the doghouse...

Jeffrey Williams (6/24/2009)

---

Okay, since this was a cancelled restore you should be able to right-click the restoring database and delete it. Once deleted, you can then delete the mdf/ldf...

By default, every table should have a clustering index !

If you don't have one now, convert one of the (singl column/narror) indexes.

If that CLIX doesn't serve you well, you pick...

my 2ct.

"It doesn't matter" is to heavy, because you may need to restore more pages than with a nicely 100% organized db.

However, you will need the original databases file sizes...

Dave (6/24/2009)

---

I was trying to move a SS2000 database to a SS2005 server. I backed up the SS2000 database, copied the .bak file to the SS2005 box, and started...

- A unique key would also do just fine !

- strange .... a large...

- Be sure to add GDR R2 to your vstedba (datadude) because it adds some nice db-features.

( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed )

FYI: The Datadude's lair: http://blogs.msdn.com/gertd/default.aspx 😉

I'm not yet a user, but I...