MSSQL Backup History Query
To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup time. It will also...
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup time. It will also...
I need to find a way to see if the backup chain where broken. On my search I found this could script, created by “hot2use”I have found this script on a forum.https://dba.stackexchange.com/questions/204883/how-to-tell-if-a-backup-log-chain-is-broken The script...
When taking backup of a SQL server i got this error in my event viewer, every times the backup is running:Event Viewer Error: Cryptographic Services failed while processing the OnIdentity() call in the System...
If you want to take a backup from Microsoft SQL Server management Studio, and get this error: Operating system error 5(error not found), then the problems is that the user running SQL Server services...
If you want to restore a Microsoft SQL database, from a fuld backup, and put some transaction log file into it. (This backup has backup by ahsay) This is the why to do it:...
Installation of the Ashay Client: Download the Ahsay Client: http://eval.ahsay.com/obs/download/obm-win.exe After the installation please apply the latest hotfix. http://download.ahsay.com/support/hot-fixes/55/obm-win-hotfix.zip Put the content of the hotfix into the folder: c:\program files\ahsayobm\ Disable Continous Backup services...
USE <databasename> GO DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) BACKUP LOG <databasename> WITH TRUNCATE_ONLY DBCC SHRINKFILE(‘<logfilename-logical name>’, 1) GO
If you have follow my guide howto to backup exchange from Arcserve R12, but still have problems with backup the exchange server. Try to search in global address book, in outlook if you can...
Logon to the backup server [Administration Console] Under the [Manage System] page, enter another [User Home] (in this case, E:\User) in the [New] textbox provided and press the [Update] button Shutdown the backup service...
Many of my hits come from search engine, and Exchange and Arcserve R12 setup, is one of the most common. So here come a little howto to setup Exchange R12, with Exchange. Database Backup...
Sidste kommentar