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 - 2003-07-01 : 07:31:55
|
| Paul writes "We have a SQL transaction log backup running on our server every 30 mins.If we call our stored procedure just as this backup is running, our stored procedure still commits but the information is incorrect.There are no problems with the procedure at any other time.How do I prevent our procedure from running at the same time as the SQL Transaction Log backup.Or am I not writing the sp correctly.N.B. I am not an expert as you can see.Thanks" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-01 : 10:04:31
|
quote:
If we call our stored procedure just as this backup is running, our stored procedure still commits but the information is incorrect.
Geez...another miracleI highly doubt your assumption.What tells you that the information is incorrect? What version of SQL Server?PS There are no miracles.Brett8-) |
 |
|
|
|
|
|
Stored Procedure error re SQL Tran backup