Activity overview
Latest activity by hungnn
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?
VDI Error 1010
Setting up log shipping - Failed
================================
Backing up source database - Successful
This operation completed successfully.
Backing up HCN (full database) on HCNSYSTEM instanc...
Backup and restore between SQL 2005 and SQL 2000
Hi
I just wonder whether I can use SQL Backup to backup and restore database from SQL Server 2005 Express Edition into SQL 2000 or vice versa. I got the mix of using SQL 2005 and SQL 2000 so I just...
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
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...
Full and different backup
Hi Petey
I tried the following scenario: Full backup everyweek, different backup every day and transaction log backup every 1 hour. The thing in here was: SQL Backup allows me to run the different ...
VDI Error 1010: Failed to get the configuration
Hi Iam running the log shipping between two tests server at the moment. We have one database instance with two databases need to logged ship from source to destination server. Two log shipping job ...
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...