Re: Installing SQL server and restoring a DB on a virtual machine

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

A restore will restore to the original state of the db at the backup time.
So, you will need enough disk space to hold the original size.

--
-oj



"Marilyn" <Marilyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF6DACFE-1D08-4F82-A521-F88B565CFE16@xxxxxxxxxxxxxxxx
I have a local PC that I had installed SQL server, analysis services,
integration services etc.. on. I also had a sql db. Because I am using
OLAP
the log file for the db is 1/2 of my disk space! In order to cut down on
the
size of this log file (as well as some other reasons) I created a virtual
machine on my local pc. The local macahine has 16GB. So this morning I
backed up my db, removed the installation of SQL and all its componenets
and
am ready to move everything over to my virtual machine.
My problem is that the log file is too big for my virtual system! If I
install SQL on the virtual machine and restore the backup will the system
by
default use 1/2 of the virtual machine space for the log or will it
actually
need the 33.4GB that it had prior to the backup?

I don't want to mess things up even more so I'd like some suggestions on
what actions would be best.
fyi...
Another reason I needed a virtual machine is that I want to allow OLAP
measures to be non-aggregate and I can only do that with SQL Enterprise on
a
Windows Server; which is my virtual machine.

thanks,
Marilyn




.

Relevant Pages

  • Re: [Fedora-xen] How to Backup and Restore MBR within Logical Volumes?
    ... Then I would see the partitions of the virtual machine within a logical ... I can't backup the Master Boot ... restore the LVM metadata, i.e. the configuration files for all the ... restore the filesystems of my domU ...
    (Fedora)
  • Re: Restore problem
    ... backing up the shares off the old one, when I go to do a restore, ... Backed up Operations share from old server to a file on new server. ... Restore stops at 560MB and reports it is out of disk space. ... Did you verify that the backup file was good when you ran the ...
    (microsoft.public.windows.server.general)
  • Re: ISA 2000 Restore Options to get at only Site and Content Rules from a .bif
    ... be very easy and painless to set up a virtual machine with ISA on it so that ... you can import that backup and inspect the rules. ... configure it relatively identical with the actual ISA machine, ... Without creating a restore ...
    (microsoft.public.isaserver)
  • Re: ISA 2000 Restore Options to get at only Site and Content Rules from a .bif
    ... > be very easy and painless to set up a virtual machine with ISA on it so that ... > you can import that backup and inspect the rules. ... > configure it relatively identical with the actual ISA machine, ... Without creating a restore ...
    (microsoft.public.isaserver)
  • Re: Shrink /home to make space for /usr
    ... You only need to backup /home, then umount ... and remove /home, re-create it smaller, and restore. ... If you have enough disk space on another filesystem, ...
    (comp.unix.aix)