Skip to main content

Backing up selected files from a local local PC

Thread needs solution

Hello,

I'm having so much trouble with backing up my system that I'm having to manually backup my SQL *bak file every night to my local PC. - The tech’s say the problem is VSS but I'm not sure  - if I back up each virtual server one at a time it works fine. One tech say that there was not enough disk space on the drive to create the shadow data file. So I added a local drive plenty big to do this, it still failed. So I'm doing a v-server (5 of them on this host) one at a time allowing plenty of time for each so nothing overlaps. As a backup I go into my SQL server and every night backup the *.bak that SQL creates. Then I copy it to my PC.

Question: What do I need to do to backup these (*.bak files 2.5 GB in size ) from my PC  back to my backup drive on the HV - server?

Is there an agent that needs to be loaded?

I trying to use the agent in that came with my 11.5 SW, but it won't install because of the true image SW running on my PC.

I can do this manually of course and I might sound a little lazy but it's more like not remembering or not having the time!!

I might just have to create a script to back these files to my backup drive on the server and schedule a task to run automatically.

Any ideals that you may have will be much  appreciated.

Thank you,

Jim

 

0 Users found this helpful
frestogaslorastaswastavewroviwroclolacorashibushurutraciwrubrishabenichikucrijorejenufrilomuwrigaslowrikejawrachosleratiswurelaseriprouobrunoviswosuthitribrepakotritopislivadrauibretisetewrapenuwrapi
Posts: 250
Comments: 7092

Hello JimH,

Thank you for your posting! I would suggest the following options:

1. You could stop the SQL-Databases using Pre/Post data capture commands and start them after the snapshot is created. It would take not much time and would not affect the databases. With the idle SQL you can create normal backup of the system and it will be consistent;

2. You could also install the Agent for SQL onto machine with SQL and use Single-Pass backup option. A single-pass backup operation creates an application-aware disk backup which enables browsing and recovery of the backed-up application data without recovering the entire disk or volume. The disk or volume can also be recovered as a whole. This means that a single solution and a single backup plan can be used for both the disaster recovery and data protection purposes. The application logs can be truncated after the backup, if necessary.

Thank you,