Thread: sql server 2005 won't perform
03-22-07, 07:35 #1Registered User
- Join Date
- Jul 2004
Unanswered: sql server 2005 won't perform
I had my IT dept. install sql server 2005 enterprise edition on a new windows server 2003. All other machines are running sql 2000 server on windows server 2000. I am a sa and local admin on all servers. I tried performing copy database, backup and restore and detach and attach to upgrade the sql server 2000 databases to 2005 and all fail. I followed all steps. I was imformed that IT installed sp2 for sql server 2005. It's like the servers dont talk to each other. Their all on the company's domain. I am wondering if something happen with the install but the IT dept. insist that everything went fine. It's strange that I can't perform a simple backup and restore it on the new server buy when I click on restore it doesn't let me browse to get the backup file on the 2000 server. I never had a problem in Sql 2000 with backup. Can it be the installation was corrupted somehow. It seems fine. I haven't created any new databases because I wanted to move the databases from sql 2000. Can anyone help me get a clue of what the problem is please?
03-22-07, 08:06 #2Annie's Dog Walker
Provided Answers: 6
- Join Date
- Nov 2004
- on the wrong server
i bet your the sql server service and the sql agent service are under the local system account instead of a domain user account that has access to the other machines.If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry. Earnest Hemingway, A Farewell To Arms.
03-22-07, 08:50 #3King of Understatement
- Join Date
- Feb 2004
- One Flump in One Place
... or maybe double hop.
In any event I would copy the backup to the destination server and restore from the local file. Any blip in the network could crash your restore operation if you restore from a remote file.
ur codings are working excelent.