Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2003-07-16 : 11:01:06
|
| Hi I have the following problemThere are two sql serverOn the first there is Enerprise Edition (EE) and second is Desktop Engine(DE).My sql has EE, and my task is to make backup for one database from the other sql DE to file on my computer. I made New SQL Server Registration to DE Sql and I tryed to start SQL Server Agent on DE computer from my computer but I got the massage:An error 5 (Access is denied) occurred while performing this service operation on the sqlserveragent service.I tryed to make a job from my computer on the other (DE) but when I start the job i got the massage: SQL Server is not currently running.How can I solve this problem, and make backup work correctly.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-16 : 12:17:49
|
| First figure out which account is the SQLSERVERAGENT service using to log into the machine. Then verify if the account has administrative privileges, and if it doesn't, then grant that. Then try to start the service again. If that doesn't work, check the Event Log to see if there is any other information. You might also want to try to start the service from the actual machine and not from your machine.But why are you bothering with jobs at this point since you don't need to for your task. Just run the backup in Query Analyzer, copy the backup file to the other server, then perform restore on this server.Tara |
 |
|
|
acko
Yak Posting Veteran
52 Posts |
Posted - 2003-07-17 : 06:16:52
|
Here is the point.I do not need the database from DE server. Just bak file has to be on my computer.I know that i could do it in Query Analyzer but then this task i have to do every day and i wanted it automaticly.Thanksps Do you know something about multi server jobs and master serverquote:
First figure out which account is the SQLSERVERAGENT service using to log into the machine. Then verify if the account has administrative privileges, and if it doesn't, then grant that. Then try to start the service again. If that doesn't work, check the Event Log to see if there is any other information. You might also want to try to start the service from the actual machine and not from your machine.But why are you bothering with jobs at this point since you don't need to for your task. Just run the backup in Query Analyzer, copy the backup file to the other server, then perform restore on this server.Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-17 : 12:24:54
|
| If you are just going to copy the BAK file over to the other server, then don't bother with SQL Server. Use the Windows Scheduler which is called Scheduled Tasks instead.I have done some work on multi server administration. What is your question about it?Tara |
|
|
|
acko
Yak Posting Veteran
52 Posts |
Posted - 2003-07-18 : 06:47:56
|
I do not have any specific quastion. Just global informations, what are the benefites, what i can do whith it, and maybe can i make my problem solved whith it?p.s. How long have you been working with sql server???quote:
If you are just going to copy the BAK file over to the other server, then don't bother with SQL Server. Use the Windows Scheduler which is called Scheduled Tasks instead.I have done some work on multi server administration. What is your question about it?Tara
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-18 : 12:26:54
|
| Well with SQL Server, you will need a license in order to use it. So since you don't need to use SQL Server on this server, then why bother spending the money? You've already got Windows 2000, so just use its scheduler. It looks very much like the SQL Server scheduler anyway. You can find the Windows scheduler in Control Panel.I've been working with SQL Server since 1996.Tara |
|
|
|
|
|
|
|
|
SQL Server 2000 Desktop Engine