| Author |
Topic |
|
digitaltransfer
Starting Member
20 Posts |
 Posted - 2009-02-04 : 05:38:09
|
| right I have windows 2000 small business server and the system will not run due to an LTF file being to big I know where the file is but first off I cannot access the server in recovery mode ? I have tried but it states the password is incorrect !! obviously this is the first of my problems, my idea was to initally purchase a new bigger drive and transfer the data on to the new one so it will allow me to access the machine ? hopefully ? so with this being the case what software or things can I use to easily transfer the data from the hard drive to the new drive ? alternatively I do have a 2 x 500 gb external drives that I was using for back ups I could you one of these to store the data on then transfer it to the new drive which I have purchased today the original drive was only 80gb I have purchased a 750 gb to ensure this does not happen again,so then if I transfer the data and once again it will not accept my password how do I over come these problems My idea was to upgrade from sbs 2000 - 2003 what problems will I face with this as well as it looks like it is not an easy trasnfer ?Any help would be greatly appreciated Thanks in advance Russell |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-04 : 07:28:38
|
| hi DigitalTransfer:Can you clarify your problem a little more:Are you able to log into the server at all?What is the exact error message you are getting?2000 small business server is a customised version of Microsoft Server 2000 isn't it?Do you know what version (edition) of Microsoft SQL server you are running on the machine. I suspect you have the free edition that imposes a 2Gb limit on database size.Regards,Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-04 : 07:46:50
|
| Charlie thanks for the help I cannot log on to the server at the mo at all the error report says log in to it via the recovery console which I have tried but it would not accept my password, I am in the process of copying the data off the disc and putting it on to a external hard drive to then copy on to a new bigger drive I am not sure on the edition of the SQL I think it came with the SBS 2000 pacakge ? from memory sossry I think it is server 2000 not sbs ?Thanks for any help REgards Russell |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-04 : 07:53:56
|
| OK.Do you have any backups? When is the latest?What does that server do? if it's 2000 SBS I think that has to be a domain controller?How are you getting the data off the server if you can't log in?If the sql service is still running then taking the mdf and ldf files might not help you -- they will likely be marked suspect when you try and mount them elsewhere.Is there an administrator account on the server that you can log in as? -- does anyone have the credentials for that account locked away somewhere?A bit of history might be helpful.What happened to cause this? When did the machine last work? What exactly is the error message? (you mention an LTF file == where are you getting this info?)Is the database the only important thing on the machine?Charlie.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-04 : 08:57:50
|
| This has been a problem for a while but I managed to back up some of the data on to an external hard drive a while ago so I added files from there, and have not used the database since October last year, it seemed to have a power surge even though it is on a socket but when I rebooted the system it stated the memory was too low to boot up so I would have to go in to the recovery console and access the file and copy or compress the LFT files, but as I say I could not access the systems with the administrator password I have used for 4 years ? I used to use a PC co but they went bust and at the mo have not got the £ to pay out in these credit crunch times, clients and money is hard to get out of them as I am sure you all know !! I am in the process of copying the data to an external drive then I have just bought a SATA drive which I will make the primary drive copy all the data on to the new 750gb hd and then boot it up from there in the hope that it will effectively work, then all I have to worry about is ensuring the passwords are all ok if not I can see that being an issue AS for other information well yes there is quite a bit on there data client data, accounts invoices you name it it is on there, external back up drive went boom about a month ago so I have lost soem information although the SQL backups I have go back to May / June 08 so I have lost some data but hopefully not everything The error message is coming up o loading win 2000 server it says it cannot open as there is insufficent memory having looked at the file there was only 5mb left of disk space if there is anything else you need let me know Russell |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-04 : 09:47:08
|
| I think I might have a suggestion:Why not take the drive out of your server. Put it into another PC / external enclosure. Mount it. and then start deleting stuff off of it you don't need.Or -- bettry yet MOVE the stuff you don't think you need off of the drive to either the new PC's drive or some other location.Once you have freed up a few gigs of space on the drive in this way, put it back where it came from and try booting the server again.Should be OK unless you are using some sort of encrypted file system.I wouldn't try a whole disk copy to the new drive unless you are comfortable getting all the boot information correct.Obviously don't delete any windows files -- anything lurking in documents folder would be a prime candidate for moving.Once you get the old server back up and running -- you should be able to log in with your windows credentials. At that point it's time to start backing up everything you need before proceeding further.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-05 : 04:17:12
|
| Hi Charlie I will try that now I did copy the disc and installed the sta disc in to the machine then got a Disc Boot Failure message so tried a few other things and still not working I have moved the log files which includes the LDF files not LTF lol :) me going key happy !! so I will let you know what happens from thereThanks again Russell |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-05 : 04:36:12
|
| Hi Russel,Moving the LDF files is not a good idea. It sounds like your system stopped suddenly so sqlserver won't have had a chance to clean up after itself.You *need* the ldf files to use your database -- they are not just dumb log files. Probably best to put them back *exactly* where they were and delete / move other files.Do you know what kind of recovery model you are using for the database(s)? If you don't need point in time recovery then you should be using SIMPLE recover model -- otherwise your LDF files will just grow and grow.Your first priority should be to get that box up and running so that you can take a FULL backup of the database. Once that's done and the backup is somewhere safe then you can breath a little more easily. If you are not using SIMPLE recovery model and don't need point in time recovery you should change also.Are there any user's files that can be moved / deleted on the box. Failing that you can delete some uneccessary programs from the "program Files" directory to free up space (if you have MS office get rid of it -- you'll free up a ton of space and not loose anything vital to system. Anything in temp folders is fair game.Don't touch the LDF files though! put them back!Charlie.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-05 : 06:36:13
|
| right it is working however getting these reports the ordinal 40 could not be located in the dynamic link libary mtslsapi.dllthe ordinal 29 could not be located in the dynamic link libary odbcbcp.dllalso SQLmanger.exe ordinal I assume that is the above ?svchost.exe application error application failed to initialise properly (0xc0000.142) click on ok to terminate applicationright now the mouse moves but does not click and also the view is very strange grey screen etc.. bugger I knew this was not going to be straight forward :( But I can log on so it is a start |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-05 : 06:47:05
|
| Well being able to log in is good..... but your system seems kinda... damaged.I'd be surprised if you can query the database without the odbc driver but you might get sqlserver to run.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-05 : 07:07:16
|
| so what do I do try to do a recovery with discs ??is that the best option at the mo ?thanks charlie for your time and paitence |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-05 : 07:24:23
|
| Well. I hesitate to offer much more advice... 1st thing I'd do is get a copy of your database mdf and ldf files. Do you know if you will need your master db for stored procs / etc?Are you even able to use the system at all?Which account are you logging in as? -- I ask because it could be a program that tries to start when you log in has going into dependency hell (wrong versions of DLL's / broken sate). If there is an administrator account (which there should on a 2000 server) then, if you know the credentials you can log in as that instead.Re: recovering the actual database == I'd ask some of the more experienced dba's here for advice. I'd try Sodeep -- he seems to know an awful lot about fixing broken databases or re-attaching db's without the master db.What did you do to get the system bootable?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-05 : 07:42:07
|
| i copied the log files to the back up disc and that freed up 60gb on the hard drive, my intensions are when they are recovered I will reinstall them and the database to the new 750 HD and use that as the main point for the database leaving enough space on the main drive for day to day activitiesI am now trying to repair the OS with the recovery / repair discs so I will see what happens there and take it forward from there I will let you know how we get on and speak to you soon Thanks again for all the help so far so good !! PS yes I am logged on as the admin I have also changed pwords not sure if someone accessed it to make changes ? but it would not connect to the net before all this happened but TBH I was not bothered as long as I had access to the DB then that way no one could access and change the files which was fine with me also meant I did not have to worry about Viruses etc.. even though I have full protection REgards Russell |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-05 : 10:18:01
|
| Ok -- I'm glad things are moving for you.I still think that you might be using the wrong recovery model for your database. if you don't need point in time recovery then you should really think about moving to a simple recovery model.You might want to follow this link for more information:http://msdn.microsoft.com/en-us/library/ms191164.aspxAlso -- make sure that you porform actuall backups of your database(S) rather than relying on windows backups (if that's what you are using). Getting the database up and running from the mdf files and ldf files only can be difficult / impossible depending on the state they are in.Best of luck.Charlie.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-05 : 10:41:29
|
| the cmopany I used had done SQL backups which were stores on another drive if you want to see them email directly russell@mbiconsulting.co.uk and we can sort it from there charlie ? at the mo I have the back up drive on a different machine Regards Russell |
|
|
|
|
urgent help required