Hey there,

I am not one for the how fast can this versus that run and thats mostly because the difference is usually minimal. I have learned that over the...

I can not as this went thru SSMS =[ sorry but it was pretty straight forward.

-D-

I think this is a lost casue and i may have to...

Glad you asked..the first one (old)is stuck.. been stuck for over 15 hours minimal. The second (new)database is up and working. I tried to restore the first ...

No sharepoint services on the server just yet.... but they will be once i pass it over to the Apps team.

Thanks for the insight and looking from a different angle.

-D-

Also just to answer your question ..no snapshots.. yet..that too is something that will be set up later. But we do have the infrastructure already set and ready to rock...

Well i am in the process of building a new server...so moved the data in this particulare database already... as i mentioned earlier and a memory refresher is that i...

Thanks for the suggestion but when i try that this is the error..

restore database WSS_1 with recovery;

Msg 3101, Level 16, State 1, Line 1

Exclusive access could not be obtained because...

thanks again..when running the query that you have suggested this is returned

ad hoc updates to system catalogs are not allowed.

all suggestions are welcomed... i will keep trying and also since...

Thanks for the reply and yes i have done all the above...

fyi the dbid does not show up in sysprocess that would say something is holding it open.

-D-

is it possible that your database has more than one file to it.. or a file in the past that was deleted and then readded? By default you are...

Thanks a ton for the replys....all is appreciated. The systems will be 24x7x365 and to some extent when i consolidate i will set some overall ground rules as to downtimes...

Thanks for the reply and i do understand the fact that i will be checking and migrating all the components as well. To answer your first question that would...

Ok..so far so good... but now i would like to know this.... please say its true 🙂 but am i able to make this one role server wide...

Thanks for the insight.. much appreciated.

-Dheath

what a task and good luck 🙂

But from what i remember i had to do it with the (Rebuildm.exe). Cant remember the location of the file but...