Activity overview
Latest activity by AlexG
is parelel restore running by default while restoring from multiple backup files (I don't see option in restore command)?
does option THREADPRIORITY will make any affect if the is no other restore running at the same time ? / comments
is parelel restore running by default while restoring from multiple backup files (I don't see option in restore command)?
does option THREADPRIORITY will make any affect if the is no other restor...
100 Mbit/s (megabit per second) / comments
100 Mbit/s (megabit per second)
SQL Backup log file 6.5.1.9
-SQL "RESTORE DATABASE [Prices] FROM DISK = '\\server_S\server_A_Prices.sqb' WITH NORECOVERY, DISCONNECT_EXISTING, REPLACE "
ERRORS AND WARNINGS
18/10/2012 8:53:32 AM: Restoring Prices (database) on INFOSYSREP instance from:
18/10/2012 8:53:32 AM: \\server_S\server_A_Prices.sqb
18/10/2012 8:53:33 AM: RESTORE DATABASE [Prices] FROM VIRTUAL_DEVICE = 'SQLBACKUP_ED741013-A3AC-49B6-A0B2-30D9A1A102AF' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY, REPLACE
18/10/2012 3:25:26 PM: Warning 204: Thread 0 warning: ReadFile failed for file: \\server_S\server_A_Prices.sqb at position: 15297677312
18/10/2012 10:44:08 AM: Re-attempt: 1
18/10/2012 10:45:09 AM: OpenTargetFile.CreateFile error: The specified network name is no longer available.
18/10/2012 10:45:39 AM: Re-attempt: 2
18/10/2012 10:45:41 AM: File (\\server_S\server_A_Prices.sqb) reopened and read succeeded (524288 bytes) at position (15297677312).
18/10/2012 3:25:26 PM:
18/10/2012 3:26:16 PM: Processed 23397736 pages for database 'Prices', file 'Prices_Data' on file 1.
18/10/2012 3:26:16 PM: Processed 0 pages for database 'Prices', file 'Prices_Log' on file 1.
18/10/2012 3:26:16 PM: Processed 70 pages for database 'Prices', file 'Prices_LOG2' on file 1.
18/10/2012 3:26:16 PM: Processed 6423 pages for database 'Prices', file 'sysft_ClientSearch' on file 1.
18/10/2012 3:26:16 PM: RESTORE DATABASE successfully processed 23404228 pages in 23490.054 seconds (8.162 MB/sec). / comments
SQL Backup log file 6.5.1.9
-SQL "RESTORE DATABASE [Prices] FROM DISK = '\\server_S\server_A_Prices.sqb' WITH NORECOVERY, DISCONNECT_EXISTING, REPLACE "
ERRORS AND WARNINGS
18/10/2012 8:53:32 AM: ...
any way to increase speed of restore ?
Hi,
we have 230 GB db on physical server - Server_A (24 CPU, 32 GB RAM)
I use THREADCOUNT = 32 , COMPRESSION = 3 , it takes only 11 min backup db to SUN drive - server_S
for data mirroring I need...
no Alert send by email when server was rebooted
Hi,
I executed shutdown -r -t 01
server was rebooted, but I did not get any alerts
setting delete old files for LOGTO option
Hi ,
use command line for backups and want set LOGTO location with option to delete old log files after N days
What is the correct option command line option ?
I don't want to set delete option us...
comand line crushing server
Hi,
I have sp, daily script all db on domain (1000+) using cursor and sql compare comand line
db ranges from sql version 2000 to to 2008 R2
recently script start crushing server,I could not locate ...
SINGLERESULTSET option in backup command for version 5
Hi,
does SINGLERESULTSET exist only in version 6
command bellow run with success on version 6.2
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [My DB] TO DISK = ''\\server01\dev\SQL2005\<AUTO>....
how to exclude timestamp in header of scripted file?
Hi, we use command line to automate version control (
saving script file to Team fundation source control)
do you have option to exclude timestamp from generated file ?
/*
Script created by SQL...
what happen to sql backup standard
Hi ,
using sql backup for several years
w have standard and pro edition.
when you had standard and pro edition main diffrence was ability
to do remote backups
Now standard version replaced by Lite ...