Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-25 : 01:13:50
|
| Tyrone writes "I received a database from someone and would like to restore it to my server. Unfortunately I get the following error message which I cannot find any further information on.Server: Msg 3021, Level 16, State 1, Line 1Cannot perform a backup or restore operation within a transaction.Server: Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally.I assume that it is a environmental/setup issues but I'm not sure. In case you need it here is the command being executed:RESTORE DATABASE Omiga4Dev FROM DISK = 'c:\temp\omiga4testdbdump.BAK'Thanks in anticipationTyrone" |
|
|
adhik
Yak Posting Veteran
66 Posts |
Posted - 2004-01-17 : 06:55:30
|
| Hi Justin,Adhik here... please refere : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=31746This is related with same problem as above, I have created seprate proedure for this restore but still i got same error.... I dont have any transaction.RegardsAdhik |
 |
|
|
|
|
|
Database restore in SQL Query Analyser