Posts
Sort by recent activity
Log shipping jobs not deleting old .sqb files in 6.3
Log shipping jobs are not deleting old .sqb files from the log shipping share using FILEOPTIONS = 3. My restore log command has Erasefiles = 4 and Fileoptions =3 which should delete files older th...
New Feature for SQL BAckup 6.4
In our standby database environment, we backup transactions on the production database and ship them to the standby database without immediately applying the logs to the standby. We want to be able...
SQL Backup Restore logshipping delay
In our standby database environment, we backup transactions on the production database and ship them to the standby database without immediately applying the logs to the standby. We want to be able...
Configuring Log Shipping for multiple databases using GUI
How Configuring Log Shipping for multiple databases using Log Shipping Wizard? See that this command can be done with command line, however it would be helpful if this capability existed in the GUI.
Script to restore fulls and diffs to new server
Do you have a script example which can restore a new database on different server which apply full, latest differential, and sequential log files?
Exteneded stored procedure syntax for multiple files
What is the syntax to backup database to three different files? When I do the following code, I get an error.
Ex.
master..sqlbackup N'-SQL "BACKUP DATABASE [wslogdb63_1] TO DISK = [\\SQL-INFRA02\J...