db server prob

[Timmy20231]

keeps on disconnecting and reconnecting every 3 seconds can anyone help please?

 

[Timmy20231]

I get "1>" now what?

 

[Kaori]

with which one? (local) or 127.0.0.1?

use the same osql command again

at 1> type these

USE LOM2
SELECT TOP 1 FLD_MAPFILENAME FROM TBL_MAPINFO
GO

You should now get something like:

FLD_MAPFILENAME
-----------------------
0110

 

[Timmy20231]

(local) and i get this after typing all that stuff...

 

[Kaori]

ok you did not restore the db called LOM2
go restore it.
since you are using sql2000, you will come across the db has a higher version and you will not be able to restore using sql2000.

goto mirfiles (below my signature)
and goto mir2td2.3 directory
and download LOM2.SQL2000.zip

It's made for SQL 2000. Data is exactly like mir2(restorethis)

 

[Timmy20231]

Get this error >< anyway round this?

 

[Weikster]

Go into options and change the paths for the file you are restoring. As you see its now trying to locate in D:\SQLdata
(see on your screenshot, there is a options tab, change paths at bottom)
Your should be something like:
C:\Program Files\Microsoft SQL Server\MSSQL\Data
and
C:\Program Files\Microsoft SQL Server\MSSQL\Log

 

[Kaori]

And please use the original database name LOM2.

 

[GoldieDragon]

I get the same error but where exactly is the options? theres more than one "Options" tab i know but doesn't say where i can change the path for the file i am restoring?

 

[IceMan]

if your use the sql 05 then restore the sql 2000 db that worked for me

 

[GoldieDragon]

Using 2000 atm