I`ve altered a procedure without backup, now I want previous script back . Is there any way to get it again?
我已经改变了一个没有备份的程序，现在我想要以前的脚本。有没有办法再次获得它？
1 个解决方案
#1
5
No, there isn't, not easily anyways. You could try looking at the transaction logs.
不，没有，反正也不容易。您可以尝试查看事务日志。
Without a backup or other place where you hold versions of the stored procedure, you can't get it back.
如果没有备份或其他您保存存储过程版本的位置，则无法将其恢复。
Check your test/dev systems - you may be lucky and a prior version may still be lingering somewhere.
检查你的测试/开发系统 - 你可能很幸运，以前的版本可能仍然在某处挥之不去。
In the future - keep all database scripts in source control so such issues can be avoided.
将来 - 将所有数据库脚本保留在源代码管理中，以避免出现此类问题。
#1
5
No, there isn't, not easily anyways. You could try looking at the transaction logs.
不，没有，反正也不容易。您可以尝试查看事务日志。
Without a backup or other place where you hold versions of the stored procedure, you can't get it back.
如果没有备份或其他您保存存储过程版本的位置，则无法将其恢复。
Check your test/dev systems - you may be lucky and a prior version may still be lingering somewhere.
检查你的测试/开发系统 - 你可能很幸运，以前的版本可能仍然在某处挥之不去。
In the future - keep all database scripts in source control so such issues can be avoided.
将来 - 将所有数据库脚本保留在源代码管理中，以避免出现此类问题。