Comments
Sort by recent activity
thanks for the reply Petey. I like the fact that Restores support search/wildcards but now here's another potential issue. Everyday I am restoring the "FULL" back up of the database(s). I only want to restore the logs after the given Full back up time for the given day. Any Ideas on how to do this?
I am thinking that this is going to be more difficult than I want it to be and will just end up writing instructions to do it in the GUI screen as I am needing this in case we have a disaster and I am not around / comments
thanks for the reply Petey. I like the fact that Restores support search/wildcards but now here's another potential issue. Everyday I am restoring the "FULL" back up of the database(s). I only ...
I believe this is exactly what I'm looking for. / comments
I believe this is exactly what I'm looking for.
I ran the job this morning at 9:02 am and there was a file out there creeated on 1/15/08 at 7:13 pm and it didn't get delted. It is well over the 24 hrs from when it was created. Any idea why this would be happening? / comments
I ran the job this morning at 9:02 am and there was a file out there creeated on 1/15/08 at 7:13 pm and it didn't get delted. It is well over the 24 hrs from when it was created. Any idea why...
this is the way my code looks:
exec master..sqlbackup '-SQL "BACKUP DATABASE DW_Data_Mart TO DISK = [D:\SQL_Backups\DW_Data_Mart.SQB] " '
As you can see I am qualifying the file name that the backup is getting saved to. By using the above code is it going to replace/overwrite the file each and every time? / comments
this is the way my code looks:
exec master..sqlbackup '-SQL "BACKUP DATABASE DW_Data_Mart TO DISK = [D:\SQL_Backups\DW_Data_Mart.SQB] " '
As you can see I am qualifying the file name that the backu...