Posts
Sort by recent activity
RG RESTORE FILELISTONLY resultset doesn't match SQL native
According to MSDN, the resultset from RESTORE FILELISTONLY should be:
declare @fileListTable table(
LogicalName nvarchar(128),
PhysicalName nvarchar(260),
[Type] ...
errors 1834, 3013, 3119, 3156 restore backup w/ full-text
DECLARE @exitCode INT
DECLARE @sqlErrorCode INT
DECLARE @strSql NVARCHAR(1000)
SET @strSql = '
-sql "RESTORE DATABASE _ynz_tx1 FROM DISK=[\\nas-sql\wilcomp_sql\temporary\YNZ_TX1_205042.sqb] WITH RE...
Server options not being retained after Apply.
Running 6.4.0.1014 on 64-bit WinSrv2008...
Server options default to File Name Format:
<TYPE>_<INSTANCE>_<DATABASE>_<DATETIME yyyymmdd_hhnnss>
I've set all my other servers to:
<SERVER>_<DATABASE>_...
restore time VERY slow (compared to native SQL restore)
SQL Backup 6.4.0.56 running on WinSrv2003 R2
Restoring a database roughly 10Gb in size from a .sqb file takes avg 43min, compared to 1min for a native .bak restore.
First restored from network stor...
RESTORE VERIFYONLY via GUI?
Is it possible to perform a RESTORE VERIFYONLY via the GUI? Or is there another preferred method to validate a backup file after it's been written? I know this can be done at backup time, but I d...
command line sync - any advantage to using source snapshot?
I'm generating a script to synchronize all databases on a given server (several hundred) against a single target database (on another server).
Is there any advantage to creating a database snapshot...
abort a job in progress
Is there any way to cancel or abort a backup job once it's launched?
I just started a "backup up every database on this server" job, only to discover the agent doesn't seem to have write privilege ...
to encrypt or not to encrypt
What are the pro's and con's where encrypting backup files are concerned? Sure, it appeals to a DBA's natural & healthy sense of paranoia, but it's bound to consume some extra time/resouces as wel...
Install GUI only
Reading the 6.4 documentation, under "Installing and upgrading the graphical user interface (GUI)":
Install the SQL Backup graphical user interface (GUI) on the computer from which you want to run...