| Author |
Topic |
|
digitaltransfer
Starting Member
20 Posts |
 Posted - 2009-02-06 : 10:25:30
|
| OK so I have been having problems, I had windows 2000 server with SQL database on it which I have managed to back up and everything seems ok well sort of !! Now I am thinking do I really need windows 2000 server or could I network the database up in XP pro ? along with printers to run backup ect as I did on windows server ? It is easy to do or should I persist with 2000 server ? having had so many errors >?just a thought I had ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 10:29:34
|
| So are you able to get into the SQL Server- Databases? We are using Windows 2000 for SQL 2000 and have no major issue with it so we have to change hardware platform. |
 |
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 10:34:33
|
| Sodeep I can see the files in program files can I access the database live nomy idea was once I had transfered all the data to a back up drive to include LDF log to reformat the new drive and install XP Pro and load files from there ? would this work ? Thanks again in advance I am just trying to make it easy for me as server 2000 did not play ball Russel |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 10:38:45
|
| as I do not need remote access or anything like that just purely to network the computers and data together and printers ?I thought this might be an easier option |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 10:45:33
|
quote:
Originally posted by digitaltransfer
Sodeep I can see the files in program files can I access the database live noCan you Open Enterprise Manager for SQL Server? my idea was once I had transfered all the data to a back up drive to include LDF log to reformat the new drive and install XP Pro and load files from there ? would this work ? Why would you wanna do this? What Edition of Windows Server you have?Remember You should be doing hot backups of databases not cold backup of mdf files.Are you SQL Server Admin or Is there someone else?Thanks again in advance I am just trying to make it easy for me as server 2000 did not play ball Russel
|
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 10:53:56
|
| Sodeep I am running a Microsoft 2000 server thinknig I would need it but do I really to run a single database and netowrk a couple of pcs together ? can I open enterprise Manager in SQL server? I am not a sql admin I am just trying to get things back up and running as they were before in program files I see ms SQL server and can access the files but do not see enterprise manager ? where would this be located ? I was doing backups mon-fri these were inplace till the thing went wrong ? I have the dos batch files ? |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 11:00:11
|
| I know my way round pcs and databases etc... but this is doing my nut in ! I just want a simple solution to have access to the database again Regards Russell |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 11:12:08
|
Put this in Run:C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.Msc You are doing Cold backup. SQL Server Databases can be backed up online called Hot Backup. |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 11:16:11
|
| MMC could not create the snap-in.Also when I added the new disc it wanted to reformat to FAt32 rather NTFS ? any reason why ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-06 : 11:18:10
|
| Do you see SQL Server in Programs? |
|
|
|
digitaltransfer
Starting Member
20 Posts |
Posted - 2009-02-06 : 11:19:01
|
| I see console report and Microsoft Servers but when try to click in get the mmc report |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-02-06 : 11:53:46
|
| Hi Russel, Sodeep,Russel had a bad stop in an earlier thread. :http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119179I'm not sure what condition his mdf / ldf files are in. I think he said the system crashed at some point so I guess sqlservice was still running. His ldf file grew to 70+ Gb on a 80 Gb hard drive. Don't know when he did a backup (sql backup) last.Last thing I knew was he had moved the mdf and ldf files somewhere safe and was going to try rebuiding the windows installation -- I think he's probably installed windows over the top of itself so his registry will probably be broken.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-06 : 12:31:28
|
| Last known backup since the thing went down was 06/08 as the other back drive failed so had to reformat it and lost a few months worth |
|
|
|
|
ok still having trouble ....