Backup SQL Database

The menu item "Backup SQL Database" does not appear as a
choice under Database Utilities when running an Access
2003 Project connected to an MSDE 2000 database on the
local machine. Why?
hi,
JBMoore wrote:
> The menu item "Backup SQL Database" does not appear as a
> choice under Database Utilities when running an Access
> 2003 Project connected to an MSDE 2000 database on the
> local machine. Why?
I've no particulary skill with Access, but the menu item is available to me
even when connected to a particular database with "public" role membership
only, as I thought that under circumstances of being member of
db_backupoperator database role at least was the reason of the menu item not
being shown... but is not the case.. ok the backup failed for insufficient
privileges :D:D
perhaps you've better post the question on Office NG...
sorry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Backup Question

Hi,

In Enterprise Manager of my SQL Server Desktop version, I selected Backup option to have back up of my db. In General tab of the menu I set schedule to recurring backup every 2 minutes on daily basisjust to test.

Now I need to change it to back up every hr or the time I desire. I tried the same way I did before. But doesnt remove the first 2 mins back up schedule instead it adds new back up (which I set for every 1 hr) copy to the location.

My question is:

How can I make disable to first back up schedule which was set for every 2 minutes? Do I need to overwrite the destination file name? Please advice.

Thanks in advance.

With kind regards,
AshfaqueSo then, you did this via SQL Server Agent under Jobs? If so; you should be able to change the properties of your original job, or simply delete the whole job.

If you did it under Maintenance Plans, same thing. Just double-click the maintenance plan you want to change, click on the Complete Backup tab, and click on the "Change" button displayed next to the schedule description.

Note: Maintenance Plans create their own SQL Agent Jobs, but it will also change them if you change the properties under "Maintance Plans".

At least; that's how it's working on my SQL Server 2000 Standard environment.|||you did this via SQL Server Agent under Jobs?
Yeah.
If you did it under Maintenance Plans
Yeah..

Thanks vich.

I will do the same you instructed and come back to you.

Thanks.
Ashfaque|||In the mean time I have another question.

I intalled same server desktop version at my office and I need to RESTORE back up of my db that I created at home.

Hence I created same db name at office and tried to restore it form the CD drive. It proced the attached error. Then I coied back file somewhere in C: drive and again tried to restore the db. But failed.

1. Can somebody explain me how to restore the db?
2. Do I need to create the same db folder name to restore the back up?
3. Why can not I restore back up from CD drive while back up is ok?
4. Do it really need to copy backup some where in hard disk and then only can copy?

Please advice.

Thanks in advance.
Ashaque|||Sorry,

Forget to attach the JPEG.

Here it is.

Ashfaque