+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
Windows Thread, Sharepoint/SQL/Virtualisation and anything else!! in Technical; Hi all, Right firstly let me start off by saying I have really enjoyed reading posts put up by fellow ...
  1. #1
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16

    Sharepoint/SQL/Virtualisation and anything else!!

    Hi all,

    Right firstly let me start off by saying I have really enjoyed reading posts put up by fellow edugeekers and it most definatley has helped me in a few very tight and near misses

    Now I need you to put your magic on this - this has done both mine and my senior techies head in!!

    From the start then:

    We have a sharepoint setup with a seperate SQL 2005 DB for all the data etc. so far so good

    We are running our of space on the C: drive on the SQL server so we bought a new server ready to take its place.

    It is build, patched, SQL 2005 installed jobs a good-un.

    A few options came to mind, reading MS way of doing this was one of them or using virtualistion.

    Because it is a critical server we thought we would get an image of the old sql server anyway (being about 9 years old) so virtualisation using the free convertor was carried out. It did this whilst the server was still switched on - BONUS

    This is where the fun begins, we bought a license for VMWare workstation installed and confiured the new virtual server, switched off the old sql server and sharepoint servers, used the image from the old sql database and started the virtual workstation

    It booted up, wanted to install some drivers it found (USB drivers) and restarted the server. It worked as expected.

    (on the VM) the C: Drive was expanded using the VMware command and then using EASUS partition software I expanded the drive.

    After it rebooted, the VM C: Drive showed the new allocated disc space and all was well

    The SQL services were restarted as normal procedure and all was well.

    Started the Sharepoint Services Server first and waited for it to complete then started the MOSS Server and started its needed services.

    Logged onto the MOSS Server to view the central admin page and it came up, showing the SQL server as the data store.

    Logged onto the VLE and 'an unexpected error has occured' error message came up and nothing else worked

    Looked around the net with no joy so had to pu everthing back to as it was.

    Now we have a shrinking database and an urgent need to do something about it!

    We wont be able to turn the sql db off anytime soon unless it is planned/weekend/after 6pm

    Any help would greatly be appreciated - or if anyone knows of anyone who maybe upto the job as a consultant (eg do this for us and tell us how you did it!)

    Thanks in advanced

    ST

  2. #2

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    I cant think straight at the moment, so i will re-read this thread tomorrow morning when i am more awake lol.

    but, have you re-created the web application on sharepoint and on the database pointed it to your sql server and the instance? and Content Database Name?

    If you have re-created the web application, then the error is quite important as it could be trying to do anything depending if you had any webparts etc on the main page before hand.. that will no longer be their as you have re-created the web application.

    Hope that makes sense.

    James.

  3. Thanks to EduTech from:

    stariq (19th August 2009)

  4. #3

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,161
    Thank Post
    95
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    Have you got the full detail of the error available? If everything else is working, it may be something in the VLE configuration.

    Also it may be worth trying a backup of the SharePoint site through stsadm - then restoring this to a new web application within the same setup. If this works, try restoring it to your virtualized server rather than relying on the image.

  5. Thanks to jamesb from:

    stariq (19th August 2009)

  6. #4
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    @edutech - no; not created the new web application or pointed it to the sql server - thought the image/virtualisation would take care of that? (maybe totally wrong??) or easy way out

    @James - will look at the sql event viewer and MOSS error directory to see anything - what should i be looking for?

    With the new sql server in place we cant connect to any of our VLE or any others we host

    Forgot to mention that there are alerts setup on the setup so if anything was updated it send an email. This would not be working if the sql db was not being recognised or am i missing something?

    I think we are nearly there with the virtualisation route - something just doesnt like it which is well annoying

    Thanks both for your replies; thanks on the way

  7. #5

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Yes Technically if you have just converted your old SQL server, Expanded the C: Drive and Turned your Physical machine off and turned on your new VM it should just work.

    I have done this in the past with both my SQL Server and Front End Server for Testing Purposes and it worked fine.

    SharePoint Should give you a more specific error, check event veiwer on both SQL and FrontEnd Server and see if anything has been flagged up.

    An error code or anything like that will give us and you more details rather then just ''an unexpected error has occured' ;~)

    Ta

    James.

  8. Thanks to EduTech from:

    stariq (19th August 2009)

  9. #6
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    cheers, starting to look at it now, the sql error log, is that on the virtual sql or the old sql database?

    if its the virtual one, it is switched off as we need our vle running for the next few weeks

    MOSS Server - starting to narrow it down with the dates/times will post something relevant in a bit

    thanks

    ST

  10. #7

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    The error log will be on the SQL Server the SharePoint Server is trying to contact at that moment in time.

    oh and you dont really want to keep switching SQL Servers

    James.

  11. Thanks to EduTech from:

    stariq (19th August 2009)

  12. #8
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    nope dont wanna be doing that!

    looking at the sql server management studio express, when you double click on the error logs it does nothing, if you right click on it its says refresh only

    will have a look around the net and see what im missing me thinks

    ST

  13. #9

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,161
    Thank Post
    95
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    When the error page appeared was it the SharePoint unexpected error page, with a link to Troubleshoot SharePoint errors? If it was then there may be a stack trace in the server's event viewer which'd help.

    If not then you should take a look at your IIS event logs (System32\LogFiles\somethingincomprehensible I believe). You can find out the path by going into IIS Manager and looking at the web site properties. This might help you narrow it down a little more.

  14. Thanks to jamesb from:

    stariq (19th August 2009)

  15. #10
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    it was more like an IIS error style if that makes any sense?

    Will look into the IIS event logs as i havnt done that

    thanks for the suggestions

    ST

  16. #11

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Oh right, so it lost the sharepoint theme then and went to an IIS White Boring Page?

    I have PM'd you

    James.

  17. Thanks to EduTech from:

    stariq (19th August 2009)

  18. #12
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    thats right, but what baffles me is that central admin works, the alerts work but cant get onto the vle or any others we have running ??

    have replied with a PM also

    Thanks

    ST

  19. #13

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,161
    Thank Post
    95
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    It sounds like SharePoint is working fine, but the sites are broken. The stsadm backup and restore might be the best way around this.

    The IIS logs would definitely be worth a look if its an IIS error page, as it may be that SharePoint is actually fine and IIS itself is having problems.

  20. Thanks to jamesb from:

    stariq (19th August 2009)

  21. #14

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    4,980
    Thank Post
    158
    Thanked 888 Times in 699 Posts
    Blog Entries
    3
    Rep Power
    265
    Yeah i agree james, thats what i was trying to say earlier.

    I have seen it happen before where the sites just break.. or it just corrupts.. if its what i think it is then yes a simple backup and restore might just correct the errors.

    Failing that, you could try creating another web application attaching the same content database and see if that one works

    James.

  22. Thanks to EduTech from:

    stariq (19th August 2009)

  23. #15
    stariq's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    186
    Thank Post
    113
    Thanked 18 Times in 16 Posts
    Rep Power
    16
    @Jamesb does the backup restore mean that i need to transfer the sharepoint moss to a new server as well as the sql server?

    Trying to find the IIS logs in sharepoint at the mo will get back to you with some data

    not sure how to attach a db to a new site; again will need to read up on this me thinks

    thanks both for all your help so far!!

    ST

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. New Virtualisation PC
    By Zoom7000 in forum Thin Client and Virtual Machines
    Replies: 19
    Last Post: 27th July 2009, 09:36 AM
  2. So what are you using virtualisation for?
    By Nozza in forum Thin Client and Virtual Machines
    Replies: 13
    Last Post: 22nd July 2009, 04:10 PM
  3. Virtualisation for Dummies
    By RabbieBurns in forum General Chat
    Replies: 0
    Last Post: 31st July 2008, 01:51 AM
  4. Virtualisation Servers
    By Gatt in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 27th March 2008, 11:32 AM
  5. virtualisation ?
    By mac_shinobi in forum Mac
    Replies: 5
    Last Post: 6th February 2008, 02:49 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •