Activity overview
Latest activity by Berg
Script to restore databse at 12.00
Hi!
I have 2 databases.
1 Sharp database
1 Test database
That i hope to do is:
Restore sharp database at 12.00 PM to test database to have newest data and all that every day.
Sharp database is back...
I hvae schudle jobs to backup Logs and remore old logs avery 1 hour.
Is only 1 log at avery time.
Log xxx is **.15 and log yyy is **.45
Its is 2 databases on that server. / comments
I hvae schudle jobs to backup Logs and remore old logs avery 1 hour.
Is only 1 log at avery time.
Log xxx is **.15 and log yyy is **.45
Its is 2 databases on that server.
Has the modified date of the license file changed, for some reason?
No
Is there a pattern to when you get the errors e.g. every 3 hours etc, and does it happen at the same time everyday?
Yes, its looks like that
00.15
02.22
03.16
12.15
16.16
20.16
Its Logs files.
Full backup is 2.00 going for 22 min.
Immediately after an error, if you were to perform a backup manually using SQL Backup, does it run successfully?
I have not test but will test that tomorrow. / comments
Has the modified date of the license file changed, for some reason?
No
Is there a pattern to when you get the errors e.g. every 3 hours etc, and does it happen at the same time everyday?
Yes, its l...
I have same problem yet.
You have same ideas how i can fix it? / comments
I have same problem yet.
You have same ideas how i can fix it?
I´m test now to reset all security settings on that folder.
I will be back on Monday if it is gone or not. / comments
I´m test now to reset all security settings on that folder.
I will be back on Monday if it is gone or not.
[SQLSTATE 42000] (Error 50000).
Hi!
I get this on 4 of my SQL servers but not all time.
I get like 4 or 5 time avery day.
Both on Log and full backup.
Executed as user: XXXX\SQLAgent. SQL Backup job failed with exitcode: 667 SQL ...
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_8086CC7C-3E09-45F3-BE37-DA6CDDCEB2E4'.
Operating system error 0x80070002(error not found).
We run Log backup (1 time avery hour) / comments
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'SQLBACKUP_8086CC7C-3E09-45F3-BE37-DA6CDDCEB2E4'.
Operating system error 0x80070002(error not found).
We run Log backup (1 time ave...