Comments
Sort by recent activity
Thanks Petey for your excellent support, I am so happy with the product and will roll out into our system. Just one more dummy question. Once i setup log shipping successfully, Will I just let it goes like this. Do I have to let say, rerun full backup/restore each month and run log shipping after that? I mean is there any maintenance I need to take care? / comments
Thanks Petey for your excellent support, I am so happy with the product and will roll out into our system. Just one more dummy question. Once i setup log shipping successfully, Will I just let it g...
Hi petey
That's mean everytime if I want to restore transaction log, I have to run this script in the destination server or I just have to run only one time? / comments
Hi petey
That's mean everytime if I want to restore transaction log, I have to run this script in the destination server or I just have to run only one time?
Hi Petey
The issue in here is that I can even Running the different backup without performing the full backup and aslo when doing this, SQL Backup did not asked me the Full Backup, it just allows me to create the Different backup straight away. That's why it makes me so confused. / comments
Hi Petey
The issue in here is that I can even Running the different backup without performing the full backup and aslo when doing this, SQL Backup did not asked me the Full Backup, it just allows m...
Hi
The problem was the destination server seems to have not enough contiguous memory block and consequently keep restore job fail. I change it during the Startup parameter by using -g 512 and it seems to be ok now. / comments
Hi
The problem was the destination server seems to have not enough contiguous memory block and consequently keep restore job fail. I change it during the Startup parameter by using -g 512 and it se...
Hi Petey
Beside of maintaining logshipping between a pair of working Server and backup server I just want to maintain the laptop incase of power failure user can still access database by using this laptop. I just want to backup database from the working server into this laptop (may be once or twice per day). We can automatically schedule the backup but cannot automate the process of restore into laptop. This is the way that I am still investigating the Redgate software
Thanks / comments
Hi Petey
Beside of maintaining logshipping between a pair of working Server and backup server I just want to maintain the laptop incase of power failure user can still access database by using this...
Hi Petey
Thanks for your prompt email. Just one question about your procedure:
You set initialize the database on ServerX with the NORECOVERY/STANDBY option. How can I do that by using command line or Query Analyzer?? and because I already setup the log shipping between the source and another destination server, can I use the full backup and transactions log backups of this pair? Sorry for the dummy question.
Is there any other option beside the logshipping. Previously I use attach/detach method and it is not safe at all with the source server. I saw you have the schedule backup jobs so I can scheduly backup the database in the shared folder. Is there anyway to automate the restore process of destination server?
Regards
Hung Nguyen / comments
Hi Petey
Thanks for your prompt email. Just one question about your procedure:
You set initialize the database on ServerX with the NORECOVERY/STANDBY option. How can I do that by using command line...