July 20, 2005 at 5:28 am
I have several Backups that are running to Disk, and appear to be completing without any problems.
However, when I View Contents from the Properties of the Back Up Device, The Date is replaced by hieroglyphics - they look like characters from the Chinese/Japanese alphabet - although the time is showing correctly.
How can I get the date to show correctly?
Gary
July 20, 2005 at 9:58 am
You can use RESTORE HEADERONLY FROM 'backup_device'
command which will give you similar info.
The information is stored in msdb database, so it would be worthwhile to check its collation as well:
select databasepropertyex('msdb','collation')
What are the results?
July 20, 2005 at 10:04 am
Actually, info about backup devices is stored in master db. Check it as well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply