Posts
Sort by recent activity
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 ...
backup while running trn log backup
Hi ,
I have server with 7 databases
2 databases (db1 = 60 GB ,db2 =40 gb)
trn log backup running for db1 and db2 ebery 15 minutes
Mirroring set for db1 and db2
I created job to backup all db at 11:...
Nice to have
Hi,
I would like to make request to Sql compare developers.
please make option to add custom note or script at begining of file
(before of after comments) and make file read only
Example
select...