March 7, 2003 at 2:47 pm
Hi All,
I running to a bit of tecnical differculty with the Model DB restore from KB-304692 instruction.
The following is what I did, it is single suer mode:
restore database model from disk='c:\mo3703' with move 'modeldev' to
'C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf',
move 'modellog' to 'C:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf',
replace
go
Error...............
Server: Msg 949, Level 16, State 1, Line 1
tempdb is skipped. You cannot run a query that requires tempdb
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
March 7, 2003 at 5:30 pm
There's a better one for SQL2K:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071
Basically start with -T3608, detach the db, then either move and reattach, or you can restore (with or without move).
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply