Page 1 of 1

Transact SQL - anyone know it?

Posted: July 19th, 2007, 10:36
by amblin
.

Posted: July 19th, 2007, 10:42
by mrbobbins
Hmm let me have a think...

Oh yeah!, the answer is:

CHEESE :cheese:

Posted: July 19th, 2007, 10:50
by amblin
.

Posted: July 19th, 2007, 11:00
by fabyak
amblin wrote:SQL says:

Code: Select all

Msg 155, Level 15, State 1, Line 5
'CHEESE' is not a recognized RESTORE option.
:P
ILoveHorses-(Best_ov_all_teh_animals)

Posted: July 19th, 2007, 11:30
by buzzmong
Couldn't you er...try guessing the file type?

Re: Transact SQL - anyone know it?

Posted: July 19th, 2007, 13:56
by cheeseandham
amblin wrote:The backup was taken using a program called EMS SQL Manager 2005 and has been created as a single file (with no file type defined - it's just a 1Gb file.)
Erm, install this program and do the restore with it?

Posted: July 19th, 2007, 15:42
by Fear
Can you not restore it in the sql manager?

I've only ever backed up with transact SQL, never restored.

Posted: July 19th, 2007, 15:51
by amblin
.