Comments
Sort by recent activity
Hello. Thank you for the answer, however that does not seem to have worked? SQL Backup log file 5.2.0.2824
10/8/2007 3:00:00 PM: Backing up DHL (transaction log) to:
10/8/2007 3:00:00 PM: C:\SQLBACKUP\Daily\TRN\DHL\LOG_(local)_DHL_20071008_150000.sqb
10/8/2007 3:00:00 PM: BACKUP LOG [DHL] TO DISK = 'C:\SQLBACKUP\Daily\TRN\<database>\<AUTO>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', VERIFY, ERASEFILES = 4, COPYTO = 'E:\SQLBACKUP\Daily\TRN\<Database>\', FILEOPTIONS = 3, COMPRESSION = 1, THREADCOUNT = 3
10/8/2007 3:00:04 PM: Backup data size : 39.000 MB
10/8/2007 3:00:04 PM: Compressed data size: 6.294 MB
10/8/2007 3:00:04 PM: Compression rate : 83.86%
Processed 3869 pages for database 'DHL', file 'DHL_Log' on file 1.
BACKUP LOG successfully processed 3869 pages in 1.306 seconds (24.263 MB/sec).
10/8/2007 3:00:04 PM:
10/8/2007 3:00:04 PM: Validating files:
10/8/2007 3:00:04 PM: C:\SQLBACKUP\Daily\TRN\DHL\LOG_(local)_DHL_20071008_150000.sqb
10/8/2007 3:00:04 PM:
10/8/2007 3:00:04 PM: RESTORE VERIFYONLY FROM DISK = 'C:\SQLBACKUP\Daily\TRN\DHL\LOG_(local)_DHL_20071008_150000.sqb'
The backup set is valid.
10/8/2007 3:00:07 PM: Copied C:\SQLBACKUP\Daily\TRN\DHL\LOG_(local)_DHL_20071008_150000.sqb to E:\SQLBACKUP\Daily\TRN\DHL\LOG_(local)_DHL_20071008_150000.sqb.
10/8/2007 3:00:07 PM: SQL Backup process ended.
10/8/2007 3:00:07 PM: Deleted msdb entries older than 8/9/2007 3:00:07 PM
10/8/2007 3:00:07 PM: Deleted local history entries older than 8/9/2007 3:00:07 PM
I have backups from 10/3/07 still in my copyto folder, which is older than 4 days old (which is what my ERASEFILES) is set to. / comments
Hello. Thank you for the answer, however that does not seem to have worked?SQL Backup log file 5.2.0.2824
10/8/2007 3:00:00 PM: Backing up DHL (transaction log) to:
10/8/2007 3:00:00 PM: ...
Jason Cook wrote:
When you use the browser, at the top left where it says "Network Shares", you can change this to the local server, and backup to a local drive. There should be no technical restrictions to using a local drive.
To clarify the difference between the MIRRORFILE and COPYTO keywords, the mirroring occurs during the backup itself (so using a USB drive will slow the backup down), the copying occurs after the backup.
Jason
Jason,
Yes I selected the local server however E: does not show up, but I can manually enter E:\path\to\backup so I'm going to give that a go.
Right now I use SQLEM to backup and then robocopy to copy to the E: drive as a second step in the process.
I appreciate your ZIPPY responses. What a company! / comments
Jason Cook wrote:
When you use the browser, at the top left where it says "Network Shares", you can change this to the local server, and backup to a local drive. There should be no technical re...
Jason Cook wrote:
In step 4 of the backup wizard (step 5 of the scheduling wizard) there is an option called "Copy backup to network", which is the GUI representation of the COPYTO keyword.
Jason
Yes but for whatever reason that does not allow me to select a local drive E drive in this case is a usb storage device attached to the SQL server. I assumed this was the mirror function and not the copy function. / comments
Jason Cook wrote:
In step 4 of the backup wizard (step 5 of the scheduling wizard) there is an option called "Copy backup to network", which is the GUI representation of the COPYTO keyword.
Jaso...
Jason,
Thank you. When I do 1 hr transaction log backups with SQLEM it is apprent that the size changes quite readily however. One hour it can be 100k, the next it can be 20k etc. This depends on the level of work being done but I can see by the size of our log when my users were most active on the database.
That's why I was confused because these were both very similar in size. Right now my log file is a bit out of whack, though. It's got a lot of inactive (empty) space according to SQLEM with very little data in it. I need to shrink it down which I guess remove inactive entries would do if I decided to tick that check box, right? / comments
Jason,
Thank you. When I do 1 hr transaction log backups with SQLEM it is apprent that the size changes quite readily however. One hour it can be 100k, the next it can be 20k etc. This depend...
Ah yes. Forgive me, it's early morning here yet. I had my truncate and shrink mixed up.
Thanks again for the help. The backup test I did last night took a less than a third of the time the SQLEM backup took, so this is promising. The only thing I cannot seem to do with the GUI scheduling is use the 'copyto' function, I can use mirror.. but that will not allow me to copy to another attached drive (backup) on the system. can this only be done with the dos command or the stored procedure?
Jason Cook wrote:
Truncating the log / "Remove inactive entries from transaction log" will indeed remove the inactive entries, but it will not shrink the file size down.
If you want to physically shrink the size of the file(s) there are two options, one shrinks a single file (e.g. the log file), one shrinks all of the files in a database:
DBCC SHRINKDATABASE (http://msdn2.microsoft.com/en-us/library/ms190488.aspx)
DBCC SHRINKFILE (http://msdn2.microsoft.com/en-us/library/ms189493.aspx)
Due to the nature of the command, the CPU usage and I/O load can be noticable for a sustained period of time (which depends on the size of the files in question), so should only be executed during a period of low utilisation.
Hope that helps,
Jason
/ comments
Ah yes. Forgive me, it's early morning here yet. I had my truncate and shrink mixed up.
Thanks again for the help. The backup test I did last night took a less than a third of the time the SQLEM...
petey wrote:
When the SQL Backup Agent service starts, it needs to grant rights to some internal objects, to both it's startup user and the associated SQL Server service's startup user.
Try setting the SQL Backup Agent service user to LocalSystem (assuming LocalSystem has the SQL Server sysadmin fixed server role). For the SQL Server service user, is it started using a domain user? Is the full name of the domain user i.e. DomainName\UserName ?
I've tried local system to no avail
I've tried DOMAINNAME\Username (3 different users).
I've tried .\Username (3 different users)
All come up with the same error.
SQLSERVER is started by .\Administrator (I verified this). / comments
petey wrote:
When the SQL Backup Agent service starts, it needs to grant rights to some internal objects, to both it's startup user and the associated SQL Server service's startup user.
Try sett...
petey wrote:
For the SQL Server service, if you can change it, could you pls try using <COMPUTERNAME>\Administrator instead of .\Administrator?
I could, yes. But I cannot restart the service as people are connected.
Ok, I changed both the SQLSERVER and the SQLBACKUP program to DOMAIN\Administrator and it works (without a sql server restart).
weird. / comments
petey wrote:
For the SQL Server service, if you can change it, could you pls try using <COMPUTERNAME>\Administrator instead of .\Administrator?
I could, yes. But I cannot restart the service ...
Brian Donahue wrote:
Hello,
This is a fairly standard error. SQL Backup Agent is set to log on as a domain account and the domain is unavailable to verify the login. There is either a network problem or the account has been deleted from the domain or is invalid.
You can try changing the account that the SQL Backup Agent service runs under. Possibly re-entering the account intormation into the LogOn tab may help if the account had been deleted and recreated.
This is installed directly on my SBS2k3 server. So there is certainly no network issue involved here.
I've tried three different login users (admin, myself and another user) that all have rights as administrator on this machine.
I've not found a solution yet. / comments
Brian Donahue wrote:
Hello,
This is a fairly standard error. SQL Backup Agent is set to log on as a domain account and the domain is unavailable to verify the login. There is either a network pr...
Still no luck. Googling yields no extra results other than the thread I found here. / comments
Still no luck. Googling yields no extra results other than the thread I found here.
Hi. I am using 5.3.8.2 and it seems to support synonyms ok. [image] / comments
Hi. I am using 5.3.8.2 and it seems to support synonyms ok.