How can we help you today? How can we help you today?
pcassar
Activity overview Badges (0) Posts (1) Comments (3)

Comments

Sort by recent activity
Thank you, that will work perfectly! / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Auto named files in multi-file backup have different names
Thank you, that will work perfectly!
0 votes
Backup command splitting over 20 files: EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [DATABASENAME] TO DISK = ''F:\SQLBackups\<AUTO>_01.sqb'', DISK = ''F:\SQLBackups\<AUTO>_02.sqb'', DISK = ''F:\SQLBackups\<AUTO>_03.sqb'', DISK = ''F:\SQLBackups\<AUTO>_04.sqb'', DISK = ''F:\SQLBackups\<AUTO>_05.sqb'', DISK = ''F:\SQLBackups\<AUTO>_06.sqb'', DISK = ''F:\SQLBackups\<AUTO>_07.sqb'', DISK = ''F:\SQLBackups\<AUTO>_08.sqb'', DISK = ''F:\SQLBackups\<AUTO>_09.sqb'', DISK = ''F:\SQLBackups\<AUTO>_10.sqb'', DISK = ''F:\SQLBackups\<AUTO>_11.sqb'', DISK = ''F:\SQLBackups\<AUTO>_12.sqb'', DISK = ''F:\SQLBackups\<AUTO>_13.sqb'', DISK = ''F:\SQLBackups\<AUTO>_14.sqb'', DISK = ''F:\SQLBackups\<AUTO>_15.sqb'', DISK = ''F:\SQLBackups\<AUTO>_16.sqb'', DISK = ''F:\SQLBackups\<AUTO>_17.sqb'', DISK = ''F:\SQLBackups\<AUTO>_18.sqb'', DISK = ''F:\SQLBackups\<AUTO>_19.sqb'', DISK = ''F:\SQLBackups\<AUTO>_20.sqb'' WITH ERASEFILES = 1b, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 0, VERIFY, CHECKSUM"', @exitcode OUT, @sqlerrorcode OUT Here is a sample set of files generated from that: FULL_(local)_DATABASENAME_20120807_023000_14.sqb FULL_(local)_DATABASENAME_20120807_023000_15.sqb FULL_(local)_DATABASENAME_20120807_023000_16.sqb FULL_(local)_DATABASENAME_20120807_023000_17.sqb FULL_(local)_DATABASENAME_20120807_023000_18.sqb FULL_(local)_DATABASENAME_20120807_023000_19.sqb FULL_(local)_DATABASENAME_20120807_023000_20.sqb FULL_(local)_DATABASENAME_20120807_023001_01.sqb FULL_(local)_DATABASENAME_20120807_023001_02.sqb FULL_(local)_DATABASENAME_20120807_023001_03.sqb FULL_(local)_DATABASENAME_20120807_023001_04.sqb FULL_(local)_DATABASENAME_20120807_023001_05.sqb FULL_(local)_DATABASENAME_20120807_023001_06.sqb FULL_(local)_DATABASENAME_20120807_023001_07.sqb FULL_(local)_DATABASENAME_20120807_023001_08.sqb FULL_(local)_DATABASENAME_20120807_023001_09.sqb FULL_(local)_DATABASENAME_20120807_023001_10.sqb FULL_(local)_DATABASENAME_20120807_023001_11.sqb FULL_(local)_DATABASENAME_20120807_023001_12.sqb FULL_(local)_DATABASENAME_20120807_023001_13.sqb File name format (this is the default): <TYPE>_<INSTANCE>_<DATABASE>_<DATETIME yyyymmdd_hhnnss> I can remove the seconds portion from the <AUTO> but the same thing could happen when crossing to a new minute. Thanks for the help! / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Auto named files in multi-file backup have different names
Backup command splitting over 20 files: EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [DATABASENAME] TO DISK = ''F:\SQLBackups\<AUTO>_01.sqb'', DISK = ''F:\SQLBackups\<AUTO>_02.sqb'', DISK = ''F...
0 votes
Can I have the fix emailed or PMed to me also please? Thanks / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Retry Connection after Monitoring Stopped
Can I have the fix emailed or PMed to me also please? Thanks
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2