Comments
Sort by recent activity
Another vote for me, I don't think I've seen this in SQL Backup yet
Recently I had to manually remove the
FILECOUNT = 2
string from the command so that I can backup to 1 file per DB, instead of 2 (which is the minimum I can change to in the GUI, cannot change to 1) / comments
Another vote for me, I don't think I've seen this in SQL Backup yet
Recently I had to manually remove the
FILECOUNT = 2
string from the command so that I can backup to 1 file per DB, instead of 2 (...
+1 for me as well
+1 for this feature in SQL Compare too :P / comments
+1 for me as well
+1 for this feature in SQL Compare too :P
sorry to bump up the old thread
but this should be a Feature Request for next version as well
It is MUCH easier to go to File -> Export servers, and pick a Save location
vs digging deep into the hidden folder [image]
C:\Documents and Settings\jerryhung\Application Data\red gate\SQL Backup, and copy Servers.dat / comments
sorry to bump up the old thread
but this should be a Feature Request for next version as well
It is MUCH easier to go to File -> Export servers, and pick a Save location
vs digging deep into the hi...
I am certain I have this issue since 3.6 as well
1. typing TR... won't prompt "TRUNCATE" keyword
2. It doesn't prompt for table candidates after TRUNCATE TABLE
Note. It does CAPITALIZE the keywords into TRUNCATE TABLE
Tried to add TRUNCATE or TRUNCATE TABLE to Triggering Words, no good either; it'd be nice to add it / comments
I am certain I have this issue since 3.6 as well
1. typing TR... won't prompt "TRUNCATE" keyword
2. It doesn't prompt for table candidates after TRUNCATE TABLE
Note. It does CAPITALIZE the keywords...
Very neat idea, thank you
Definitely something to use and customize for / comments
Very neat idea, thank you
Definitely something to use and customize for
Thanks for the reply, that feature matrix was awesome
Too bad the Standard edition doesn't do format, but I'll start conversation with my manager
I had old SQL Prompt license (4.x) and still barely works, but would prefer newer version if company allows it / comments
Thanks for the reply, that feature matrix was awesome
Too bad the Standard edition doesn't do format, but I'll start conversation with my manager
I had old SQL Prompt license (4.x) and still barely...
I have always done the manual (using SQBServerSetup.exe) install on each of my cluster nodes. Feels safer that way without permission issues
This is for both 2005 SP3 and 2008 R2 clusters / comments
I have always done the manual (using SQBServerSetup.exe) install on each of my cluster nodes. Feels safer that way without permission issues
This is for both 2005 SP3 and 2008 R2 clusters
Interesting
I just did a SQL 2008 R2 on a Windows 2008 R2 install last week also, CLUSTER
Ran the Setup.exe locally for both clusters
Had to add the DOMAIN\account into [sysadmin] because I forgot, but that's the only issue I had, everything went smoothly, no settings changed / comments
Interesting
I just did a SQL 2008 R2 on a Windows 2008 R2 install last week also, CLUSTER
Ran the Setup.exe locally for both clusters
Had to add the DOMAIN\account into [sysadmin] because I forgot,...
This is what I use for Backup summary
Even better if you run this across the Central Management Servers (CMS) to grab a summary of ALL the servers in CMS EXEC master..sqbdata '
SELECT dbname
,backup_start, backup_end
,backup_type
,duration AS [seconds]
,BH.size/1000 AS [Size_KB]
,BH.compressed_size/1000 AS [CompressedSize_KB]
,speed,encryption
,compression_ratio
,compression_level
,BF.name AS filename
--,logfilename
--,convert(nvarchar(19),backup_start,100) as Backup_Start
,DATEPART(hh,backup_start) AS [hour]
FROM backuphistory BH
INNER JOIN backupfiles BF ON BH.id = BF.backup_id
WHERE 1=1
AND DATEDIFF(d,backup_start, getdate()) = 1 -- less than X days old
AND backup_type = ''L''
AND dbname = ''XXXX''
ORDER BY BH.id DESC
'
/ comments
This is what I use for Backup summary
Even better if you run this across the Central Management Servers (CMS) to grab a summary of ALL the servers in CMSEXEC master..sqbdata '
SELECT dbname
,b...
jchertudi wrote:
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a restore, when I select a transaction log, it only selects files back to the prior Full backup. Do these sort of restores need to be run via SSMS??
Yes, you need to do this in scripts, not via UI
Restore last sunday's FULL backup, in NONRECOVERY mode
Restore all remaining LOG backups, all in NONRECOVERY as well
Monday, Tuesday, Wed, Thurs, Friday
then restore Saturday's LOG backup
RESTORE FROM DISK = '....' WITH STOPAT = 'Saturday 1 pm'
RESTORE LOG { database_name }
< file_or_filegroup_or_pages > [ ,...n ]
[ FROM { DISK } = { 'physical_backup_device_name' | 'file_search_pattern' } ] [ ,...n ]
[ WITH
....
[ [ , ] { STOPAT = { 'date_time' | @date_time_var } ]
| STOPATMARK = { 'mark_name' | 'lsn:lsn_number' }
[ AFTER 'datetime' ]
| STOPBEFOREMARK = { 'mark_name' | 'lsn:lsn_number' }
[ AFTER 'datetime']
} ]
/ comments
jchertudi wrote:
Thanks for the response Peter! I had thought this would be the case and tried to do such a restore, but got an error message.
Also, the SQB UI doesn't seem to support such a res...