Activity overview
Latest activity by programmer76
logshipping with multiple databases
Hi gurus,
I have to do log shipping for all the 100 database located on the production server. When i go and try to do it by wizard it will only let me do the log shipping set up for 1 database at ...
Thanks for your prompt reply. What should have caused the memory allocation issues? Does it occur because SQL server requires more memory Or may be by accident for some time sql server services were stopped and restatred ( i'm checking that with network admin)?
Becuase for peace of mind i really want to see job successfully run message and it is difficult to test this big back up on other server because of size constraints. If i really need more memory then job will again fail with the same message. Right?
Also can you please let me know some samples on how to use some command to check integrity of this .sqb backup.
Thanks / comments
Thanks for your prompt reply. What should have caused the memory allocation issues? Does it occur because SQL server requires more memory Or may be by accident for some time sql server services we...
Is this back up good?
Hi,
I ran the job using red gate to backup this database. Job status says failed in the sql server agent history. In the red gate error logs here is the message i'm seeing...
SQL Backup log file
8/...
failed job status still says executing
Hi,
Even the red get backup jobs I have created have either failed or cancelled because of not enough space in the disk where I was backing up the database, I still see job status as "executing Jo...
Hi Jason,
I looked in to it deeper and the reason the backup file size is not increasing is that there was not enough space left on the disk where we were putting this back up.
All the other backup jobs in sql server which started after this job has failed specifically giving message that there is not enough disk space to perform back up. But this job has not failed. Even right now it's status says executing even when there was no disk space.
I also ran your command master..sqbstatus 1. "processed (bytes)" and "compressed (bytes)" column values remain unchanged.
Now to take care of this issue I emptied more than enough space on the back up disk. But even after that still the job status remains executing but there is no change in the back up file size and also the processed and compressed column values remain unchanged.
What does mean? I have a big 400 GB incomplete backup file but I guess it's not good?Is this job is unsuccessful even though we don't see any error message Or is there any other way to tackle this OR I have to start the back up again from scratch?
Thanks / comments
Hi Jason,
I looked in to it deeper and the reason the backup file size is not increasing is that there was not enough space left on the disk where we were putting this back up.
All the other backup...
backup job
Hi,
i started a full database backup job for a very large Database around 500 GB. When I go to SQL management- JObs and If I refresh over there I still see the status of the job is still executing....
sql native rememebers history redgate doesn't?
Hi,
I had a backup of database using red-gate. I deleted the database after that becauest it was needed. When I deleted it I uncheck the option to delete the back up/restore history for the databas...