Can't perform a backup or restore operation within a transaction [duplicate]

Multi tool use

up vote
-3
down vote

favorite

This question already has an answer here:

Cannot perform a backup or restore operation within a transaction

2 answers

I am trying to restore a transaction log to the database with a Python script. But I get an error message

cannot perform a backup or restore operation within a transaction

How can I solve this problem?

query_ms=r"""
RESTORE LOG [miadmfggp_live] FROM
DISK =N'C:yardi_backupextract201811081130.bak0',
WITH STANDBY =N'C:Program FilesMicrosoft SQL ServerMSSQL12.YARDI_BACKUP_DEVMSSQLBackupstandby_log_file.bak' ;
"""
cursor_ms.execute(query_ms)
result=cursor_ms.fetchone()

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

marked as duplicate by petezurich, Mitch Wheat sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Nov 8 at 22:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add a comment |

up vote
-3
down vote

favorite

This question already has an answer here:

Cannot perform a backup or restore operation within a transaction

2 answers

I am trying to restore a transaction log to the database with a Python script. But I get an error message

cannot perform a backup or restore operation within a transaction

How can I solve this problem?

query_ms=r"""
RESTORE LOG [miadmfggp_live] FROM
DISK =N'C:yardi_backupextract201811081130.bak0',
WITH STANDBY =N'C:Program FilesMicrosoft SQL ServerMSSQL12.YARDI_BACKUP_DEVMSSQLBackupstandby_log_file.bak' ;
"""
cursor_ms.execute(query_ms)
result=cursor_ms.fetchone()

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

marked as duplicate by petezurich, Mitch Wheat sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Nov 8 at 22:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add a comment |

up vote
-3
down vote

favorite

This question already has an answer here:

Cannot perform a backup or restore operation within a transaction

2 answers

I am trying to restore a transaction log to the database with a Python script. But I get an error message

cannot perform a backup or restore operation within a transaction

How can I solve this problem?

query_ms=r"""
RESTORE LOG [miadmfggp_live] FROM
DISK =N'C:yardi_backupextract201811081130.bak0',
WITH STANDBY =N'C:Program FilesMicrosoft SQL ServerMSSQL12.YARDI_BACKUP_DEVMSSQLBackupstandby_log_file.bak' ;
"""
cursor_ms.execute(query_ms)
result=cursor_ms.fetchone()

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

This question already has an answer here:

Cannot perform a backup or restore operation within a transaction

2 answers

I am trying to restore a transaction log to the database with a Python script. But I get an error message

cannot perform a backup or restore operation within a transaction

How can I solve this problem?

query_ms=r"""
RESTORE LOG [miadmfggp_live] FROM
DISK =N'C:yardi_backupextract201811081130.bak0',
WITH STANDBY =N'C:Program FilesMicrosoft SQL ServerMSSQL12.YARDI_BACKUP_DEVMSSQLBackupstandby_log_file.bak' ;
"""
cursor_ms.execute(query_ms)
result=cursor_ms.fetchone()

This question already has an answer here:

Cannot perform a backup or restore operation within a transaction

2 answers

python sql sql-server

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

edited Nov 8 at 22:23

petezurich

3,37881633

edited Nov 8 at 22:23

petezurich

3,37881633

edited Nov 8 at 22:23

petezurich

3,37881633

asked Nov 8 at 22:08

Yang L

223

asked Nov 8 at 22:08

Yang L

223

asked Nov 8 at 22:08

Yang L

223

marked as duplicate by petezurich, Mitch Wheat sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Nov 8 at 22:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

marked as duplicate by petezurich, Mitch Wheat sql
Users with the sql badge can single-handedly close sql questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Nov 8 at 22:39

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

cursor_ms.autocommit='true' could solve the problem

answered Nov 8 at 22:33

Yang L

223

add a comment |

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

cursor_ms.autocommit='true' could solve the problem

answered Nov 8 at 22:33

Yang L

223

add a comment |

up vote
0
down vote

cursor_ms.autocommit='true' could solve the problem

answered Nov 8 at 22:33

Yang L

223

add a comment |

up vote
0
down vote

cursor_ms.autocommit='true' could solve the problem

answered Nov 8 at 22:33

Yang L

223

cursor_ms.autocommit='true' could solve the problem

answered Nov 8 at 22:33

Yang L

223

answered Nov 8 at 22:33

Yang L

223

answered Nov 8 at 22:33

Yang L

223

answered Nov 8 at 22:33

Yang L

223

add a comment |

This page is only for reference, If you need detailed information, please check here

HAj,ttKG6YSM3jrw,NA4 JoBX2VNjXiAuqV9mIulKdJnn,7h lXmZc9vdt5 M2p 34SjiWCI8gw16E4D

搜尋此網誌

Dfyjkt