Activity overview
Latest activity by carmelcw
Reporting in multiple DB
Hi all,
Did any one used the Reporting for multiple DB? I have follow the help guide and created the "SQLBackupReportingDatabase" on one of my SQL server. I'm able to upload the backup and restore ...
HI Brian,
After a few try. The script of the mapdrive is only work in local machine.
I may want the script run at the server side. (force to run at server) As I find that, when I start the backup in the client machine, the SQL Backup script will run at server side. So, at that time, if the server network drive is not active, than the backup will fail. (something like cannot create file or folder.)
Now, what I can do is go to the server and refresh the network drive, than the client can start the backup again without any error.
Thanks for your help.
Best regards,
Carmel Lee / comments
HI Brian,
After a few try. The script of the mapdrive is only work in local machine.
I may want the script run at the server side. (force to run at server) As I find that, when I start the backup i...
Hi Brian,
Thanks for your help. I will try and let you know the result later.
Best regards,
Carmel Lee / comments
Hi Brian,
Thanks for your help. I will try and let you know the result later.
Best regards,
Carmel Lee
Hi Brian,
Thanks for the share. Does it mean I just copy your code in my VB program. As I see this is a JSCRIPT, do i need to use VB script instead?
My program is under VB syntax.
Thanks and regards,
Carmel Lee / comments
Hi Brian,
Thanks for the share. Does it mean I just copy your code in my VB program. As I see this is a JSCRIPT, do i need to use VB script instead?
My program is under VB syntax.
Thanks and regard...
Hi,
Under my program, I have already use the UNC name.
Regards,
Carmel Lee / comments
Hi,
Under my program, I have already use the UNC name.
Regards,
Carmel Lee
SQL backup with network drive
Hi,
I have writed a VB program which will run the backup and the file will saved in the network drive.
My problem is, everyday I need to refresh the network drive connection in the SQL server. If I...
Hi Peter,
I have checked the SQL Server Agent which is started. But It still not running at the scheduled time.
I have tried to force the job to run and It can run success.
Do you know what will occur that not run in the scheduled time?
Many thanks,
Carmel Lee / comments
Hi Peter,
I have checked the SQL Server Agent which is started. But It still not running at the scheduled time.
I have tried to force the job to run and It can run success.
Do you know what will oc...
Scheduled backup does not start
Hi,
I have used the wizard to create the Schedule backup, which backup all user database in every Mon-Fri at 12:00am.
But when I come back in the morning, the job doesn't seen to be run and there i...
Hi Brian,
Does it mean the code you provide, I can create a simple program that use the VB to do the backup?
As I plan to buy the product soon, and make sure it is working for me, like I said, user can do the backup without install any software except this simple program.
Do you think your develop team can also prepare this kind of request when ship with the product? So that make us more easily to implement to our client.
I will try to ask our programmer to do me a favour with the code you provided and let you know the result soon.
Many thanks in advance for your kind help.
Regards,
Carmel Lee / comments
Hi Brian,
Does it mean the code you provide, I can create a simple program that use the VB to do the backup?
As I plan to buy the product soon, and make sure it is working for me, like I said, user...
Simple program to run the SQL Backup job
Hi,
I have installed the SQL Backup in my MS SQL Server and I can create the backup job with this software.
My question is:
I want to allow user (not technical staff) to do the backup from their PC...