October 3, 2012 at 7:33 am
Good afternoon,
This may sound like a daft question but the backupset table on one of my servers contains 6 different server names.
Can someone explain to me how this is possible? I expected to see just one unique name!
Thanks.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 3, 2012 at 8:05 am
are you using log shipping?
---------------------------------------------------------------------
October 3, 2012 at 8:10 am
No, no log shipping.
I've done a bit more checks and it appears to be very old data. In fact the entries relate to databases that no longer exist in master.dbo.sysdatabases
I'm going to remove these entries as there is no need for them to be there!
Just intrigued how these ended up where they are. Very strange.
Thanks.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
October 3, 2012 at 8:19 am
Any database restore from another server across the network will result in an entry in the backupset table.
check msdb..restorehistory as well
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply