I have hundrends of SQL Agent jobs in SQL Server 2005 and I want to move them to another server everyday for DR purpose. I try to restore the msdb to another server but it seems that proxy could not match the credential on that server even the credentials have same name. Any suggestion for me to move jobs each night? Thanks in advance!
NIck
I have moved my database recently from a NT server to a Windows 2000 server, both running SQL 7.0 I have a couple of jobs that sometimes, work, sometimes not, the problem it tells me is that it cannot find the file specified, I run the job from enterprise manager and it runs just fine, it'll run here and there but it still fails frequently. Any suggestions on what to check? Thanks.
Bob
When I change the SA password on my server the current SQL Jobs no longer
work. How can I fix or get around this problem without rebuilding my jobs?
Hi there and happy newyear
I have a very annoying problem with my SQL Server 7.0
Here is the story:
In our compagny we have three SQL servers, SQL1, SQL2 and SQL3. The SQL1 server is our development server where we build our databases. When they are ready to go live I make an DTS package that copies the database to SQL2 and put it into a schedule.
Is it somehow possible to execute a job on SQL2 when the job on SQL1 succesfully has finished??
Cheers
Dennis
I'm new to SQL. I have a scenario, Where customer want to move all the jobs from original SQL server to some remote SQL server and want to trigger jobs on remote server to do its work on original server.
View 4 Replies View Related
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Hi,
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
Thanks.
Can anyone refer me to good 'recipes' or sources of information on thistopic??I have Visual Studio Tools for Office, which installs SS 2005 Expresslocally to my XP box, and I want to develop in SS 2005, then copy thetables or queries or reports etc. to a SS 2005 Standard server.Thank you, Tom
View 3 Replies View RelatedWe have a SQL Server 2000 ent edition sp4 with 3 small databases and one 4 GB database which is REPLICATED
The Server has been bouncing like a yoyo today because of a disk controller problem and I am preparing to move the Instance to a whole new server this afternoon. The new Server will have the same IP and name as the original server.
Any suggestions for the easiest or most seamless way to make this happen? preferably using Backup and Restore since they plan on taking the old server down completely and then building a new server with the same name and IP ... any suggestions would be appreciated.
Thanks in advance!
I have several jobs (most scripted in activeX) that I need to move to a different server. Is there an easy way to "copy and paste" them from one server to the other? (SQL7 to SQL2k)
I have a db that I created on my local machine and need to move it to our server. The problem is that I created it with sql server 2005 express and our server is a sql server 2000 so restore and attach don't work. I don't have management studio (just express) so I don't know what I need to do to move it. Any help is appreciated.
Thanks
Hello,
I moved the web app. I'm working on to another machine. Everything seemed to go well. Installed Reporting Services and configuration worked well with green ticks everywhere and I'm running reports in Report manager and in Visual Studio. However running off the web app. gives the message:
"The attempt to connect to Report Server failed" - there's also a ref. to an HTTP 404 error.
In RSWebApplication.config I have :
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
and in RSreportserver.config I have:
<UrlRoot><server IP>/Reportserver</UrlRoot>
The install might not have gone as well as I thought because there was a "ReportServer" website created in IIS at same level as default. (Also Reports and ReportServer as virtual directories under Default website). The rogue website is 'stopped' at present. Would be grateful for any help with this. One thing is that I'm now behind a proxy so I'm using localhost:8080
Can we create Jobs in Sql Server?
View 3 Replies View RelatedHi All,
I am not able to see any of the jobs in the enterprise manager that are scheduled on one of our production servers. Have any body seen this type of behaviour of SQL server.. The jobs are there in the SQL as I can query sysjobs table to see there entry.. The jobs are being executed properly when they are supposed to..
Thanks
Ajay
Hi
I need to copy all the jobs from one server to another server. How i have to do. I tried to take script of MSDB database, but it is not scripting all the jobs. PLs anyone suggest me what i have to do with scheduled jobs in 65.
it is very urgent pls.
thank u
--Rk
I have created DTS packages to export data to text files....these packages are
running...the jobs that are created to run these packages are failing ...
both the SQL SERVER and the SQL SERVER AGENT are running administrator accounts ...if the job step is run on the command line it works..so basically
some permission that invokes the the command shell is missing...jobs that run just T-SQL steps work fine too....what am i missing out?
Hi,
I have to move my SQL server data from win95 to NT.
When it comes to databases I would execute attach option.
When it comes to backup devices I think I could simply copy the folder where
backup devices are being located? IS it true??
How about moving jobs; DTS and Database Maintenance Plans???
Any Ideas??
Thanks,
Andy
Hi ,
I need to move databases and related jobs from one server to another.
I can move the database no problem. how can I get jobs moving.
Pls help me
Sunthar
Hello -
I was curious if there is any way to "copy" a SQL Job, alert etc. from one server to another. I want to test jobs on a non production server before putting them out on our live Server. I understand you can do the whole Master server thing, but this temp server is often rebuilt for whatever we need.
Any insights would be greatly appreciated...
Thanks in Advance.
Joe
Hi,
I have installed SQL server 2000 (Enterprise) on W2K advanced server using my local "Administrator" account. Using the same account for login, I have created database backup jobs on the server. After this I rename the Windows administrator account to "admin". Now I see that the jobs started failing. The error message indicates that "could not determine whether the 'server/administrator' account has access to SQL server."
Further, when I tried to troubleshoot, I discovered that the job owner name still displayed (through EM) is "server/administrator" account (this account is now renamed). I tried to change the owner name to "server/admin" but it is not getting changed. Hence, I just created a Windows user named "Administrator" and see that the Job is executing successfully.
Please note that the backup is taken on the server itself and SQL server & Agent services are running under security context of a domain account having administrator priveleges on the server.
What I am interested in knowing is what are the reasons for such behaviour? And how to rectify this problem since i really don't want the "administrator" account to be created.
Hi. i'm new to sql server jobs as i have never used the feature manually before. here is what i want to do but i don't know if it's possible.
we have a report we use that's accessed from an asp page. currently, the page uses a stored procedure to generate the data. well, as time has progressed, we've added many items to the report. it now takes a good 15-20 seconds to pull the report. what i want to do is run a job that will compile the data for me and just dump that information into a new table. does that make sense?
can this be done with sql server jobs? thank you.
I got troubles when I program a DTS package to a job. The job simply does not run.
What can I do?
Thanks for your quick answer!!
Cristopher Serrato
(Post removed)
View 3 Replies View RelatedHello all,
we just moved our databases over from a SQL 2000 server onto a new SQL 2005 server. We had no problem migrating them over, but was wondering if there was a way to migrate the jobs over as well. We have about 20 of them and would prefer not to hav to create them all again on the new server.
Thanks in advance,
Phoenix
I am creating a job for integration services in SQL server 2005 64-bit edition. I am getting error :The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI). Please help
View 3 Replies View Relatedhi every 1,
i am having a real tough time to figure this one out .
i need to find out what jobs are schedule in the server that sends data out to ever .
we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server .
i looked at the sysjobs_view , it tells the origination server and all the jobs that are running on it, but that's pretty much it.
on the sql agent , i see all the jobs but dint know which jobs are sending data out side the server .
some jobs are regular backup
maintenance jobs
how will I figure out which once are gong out .
hope you people can help . any help will be so much appreciated.
bobby
How do you copy all jobs from one server to another? Is there a way to do this programatically?
View 3 Replies View RelatedHi,
Who should own job in SQL Server 2005? Currently, I have set up a couple new jobs, the owner is a windows login with administrative privileges on the server. So the job runs fine.
When I tried to change the owner to a non-admin user, the job failed, stating that I needed to set up proxy permissions or something to that effect. So I left the owner as the admin user.
Is that ok, or even the preferred owner of jobs?
Also -
One of my job steps is calling an SSIS package. On the "general" tab, it shows that it will run the package as the SQL Server Agent, and then there is a section "Log on to Server" where you select windows or sql server login info. In this case, I the SQL Server agent is a different windows account than the job owner... so who is logging in at the package level - the job owner or the SQL Server agent account?
Thanks very much
Our company develop software based on SQL7 .
”DBA” position is really a developing (creation of triggers, stored procedure …)
Could you give an advice from you personal experience what task should I practice in order to be ready for real DBA job and how YOU moved from developer to DBA
Thanks .
I need to move Sql of the C drive on a server to another drive. Any Ideas.
Thanks Brett
Hi there!
I am fairly new to SQL Server 7. I have a SQL server database on one machine (box A).
Now I installed a new box with SQL server on it (box B).
How do I move the database from box A to box B?
What are the steps involved? What is the easiest way to do it?
What files need to be copied over?
Thanks,
Helmut
I have 55 dts packages on my production server which are to be moved on to our new server. Can anyone help me out in this regard
thanks
vas