I use VC as VM with MSDE (yes, yes, should be SQL, I know)
The backup of the VM is not a problem
What is the fastest way to backup the database?
Thanks
Seb
Use the backup database command in osql, see this kb article...
http://support.microsoft.com/kb/325003
First shutdown VirtualCenter then at a CMD prompt type osql E D prompt type the following:
BACKUP DATABASE vcdb TO DISK = 'C:\MSDE\Backup\vcdb.bak'
BACKUP LOG vcdb TO DISK = 'C:\MSDE\Backup\vcdb_log.bak'
Go
Fyi if you find this post helpful, please award points using the Helpful/Correct buttons.
-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-
Thanks, Eric
Visit my website: http://vmware-land.com
-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-
Thanks, but no matter what tool I try to use I can not connect to the MSDE_VC instance on local server
Either with sa or local administrator
Thanks
Seb
If you use "osql E D it should connect without requiring a login. Have you tried "sa" with no password?
You can try this to reset it, if you do this you will probably have to edit the ODBC connection and enter the new password.
How do I set the administrator password with MSDE?
When you install MSDE, the default login is "sa" with no password.
To change the password, open a CMD prompt by clicking on the START button, then select RUN. In the window, specify the program CMD:
A command window will appear. Enter the command:
OSQL -U sa -P
At the OSQL prompt 1> issue the command:
exec sp_password @old='', @new='MYNEWPASSWORD'
GO
OSQL will respond with Password Changed and then will display another prompt 1> Type the command QUIT and terminate the CMD window.
When you install IMbrella, you will be prompted to specify the username and password to access SQL. Specify the username sa and the new password.
Using osql I CAN connect. I have mixed mode auth with both sa & administrator with known (to me) passwords
Only any of the visual tools can not login
Not big deal, but would be nicer
Also to backup the log I needed to alter the database:
osql -E -D "Vmware VirtualCenter" -Q "ALTER DATABASE VCDB SET RECOVERY FULL"
Seb
The recovery to FULL was a very bad move as the log started filling instantly Y eventuallu MSDE gave up the ghost (took some to get it going again)
Reverted to SIMPLE & then used Teratrax Database Manager from http://www.teratrax.com/ that works perfect
Seb