VMware Cloud Community
scerazy
Enthusiast
Enthusiast
Jump to solution

MSDE backup

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

Reply
0 Kudos
1 Solution

Accepted Solutions
peetz
Leadership
Leadership
Jump to solution

There are also some free GUI tools available that implement part of the "Enterprise Manager" feature set (incl. backup):

DbaMgr2k[/url] is one of the better ones.

\- Andreas

Twitter: @VFrontDe, @ESXiPatches | https://esxi-patches.v-front.de | https://vibsdepot.v-front.de

View solution in original post

Reply
0 Kudos
7 Replies
esiebert7625
Immortal
Immortal
Jump to solution

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

-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-

peetz
Leadership
Leadership
Jump to solution

There are also some free GUI tools available that implement part of the "Enterprise Manager" feature set (incl. backup):

DbaMgr2k[/url] is one of the better ones.

\- Andreas

Twitter: @VFrontDe, @ESXiPatches | https://esxi-patches.v-front.de | https://vibsdepot.v-front.de
Reply
0 Kudos
scerazy
Enthusiast
Enthusiast
Jump to solution

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

Reply
0 Kudos
esiebert7625
Immortal
Immortal
Jump to solution

If you use "osql –E –D ” it should connect without requiring a login. Have you tried "sa" with no password?

Reply
0 Kudos
esiebert7625
Immortal
Immortal
Jump to solution

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.

Reply
0 Kudos
scerazy
Enthusiast
Enthusiast
Jump to solution

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

Reply
0 Kudos
scerazy
Enthusiast
Enthusiast
Jump to solution

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

Reply
0 Kudos