running backup and restore...

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. They also installed sql server 2005 sp2. I followed all steps. 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?

ThanksSounds like the service account for the SQL Server 2005 service has no network rights. Try copying the backup file locally, then doing the restore.

running 32bit standard edition on 64bit hardware?

I just found out that the hardware that came uses 64bit AMD. But the
Windows Server 2003 license is for Standard Edition; a 32bit version.
What kind of performance hit would I take if I ran the Standard Edition
on the 64bit hardware?
Thanks,
Mark.None.
If you install the 64 bit OS, your executables will be a bit larger and
yoyu'll use a bit more memory. But then, you can install way more memory :)
"Mark" <murkynow50@.yahoo.com> wrote in message
news:OreRLT8%23HHA.4184@.TK2MSFTNGP05.phx.gbl...
>I just found out that the hardware that came uses 64bit AMD. But the
>Windows Server 2003 license is for Standard Edition; a 32bit version.
> What kind of performance hit would I take if I ran the Standard Edition on
> the 64bit hardware?
> Thanks,
> Mark.|||Mark wrote:
> I just found out that the hardware that came uses 64bit AMD. But the
> Windows Server 2003 license is for Standard Edition; a 32bit version.
> What kind of performance hit would I take if I ran the Standard Edition
> on the 64bit hardware?
> Thanks,
> Mark.
Sorry about this posting. I meant to post it in the windows section.
Mark.

running 2005 express and 2000 side by side

If I download sql server 2005 express edition, will it run side by side with my sql server 2000, or is it a one or the other situation?

smtraber

Yes, they can work side by side.

Regards

Run SQL against SQL Server 2000 on Windows 2003 Web Edition

I have a dedicated Windows 2003 Web Edition server running SQL Server 2000.
SQL Server 2000 was pre-installed. What tools can I use to interrogate and
update the SQL Server 2000 database from the Windows 2003 Web Edition Server
?
Client and Adminstration tools are not supported and will not install on the
Web version of the 2003 operating system.Am Mon, 5 Jun 2006 04:35:02 -0700 schrieb AJ:

> I have a dedicated Windows 2003 Web Edition server running SQL Server 2000
.
> SQL Server 2000 was pre-installed. What tools can I use to interrogate an
d
> update the SQL Server 2000 database from the Windows 2003 Web Edition Serv
er?
> Client and Adminstration tools are not supported and will not install on t
he
> Web version of the 2003 operating system.
Maybe this can help you:
http://www.sqlmanager.net/en/products/mssql/manager
At the bottom you can download a free Lite-version!
bye, Helmut

Run querys after silent installtion SQL 2005 Express

Hi,

I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.

What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.

Thanks

Robert-Paul

I think you want to use sqlcmd.exe after installation. This really isn't a setup issue. You will probably get a better answer in either the Tools or DB Engine forums.|||

Moving this post to the new SQL Express forum. Hope they can answer your question.

-Jeffrey

|||

Hi Robert- Paul,

You should use SQLCmd to run .sql scripts after a silent installation. You can find more information about SQLCmd in Books Online, which you can either download or find online at http://msdn2.microsoft.com. In general, you can call SQLCmd the same way you'd call any command line tool with a command line something like this:

SQLCmd -E -S <machinename>\SQLEXPRESS -i C:\myscript.sql

Regards,

Mike Wachal - SQL Express team

run both enterprise and msde on same box

Is it possible to run both MSDE and enterprise edition (sql server 2000)
on the same box?
I am working on an application that will include MSDE, and I'd like to
test it on my developing machine that is already running Enterprise. I
could just shut off Enterprise, but the MSDE needs to be a subscriber,
so they both need to be running.
Thanks,
-Casey
hi,
C Williams wrote:
> Is it possible to run both MSDE and enterprise edition (sql server
> 2000) on the same box?
> I am working on an application that will include MSDE, and I'd like to
> test it on my developing machine that is already running Enterprise. I
> could just shut off Enterprise, but the MSDE needs to be a
> subscriber, so they both need to be running.
yes, it can be done..
up to 16 instances can be installed on the very same machine, resources
permitting :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

RULES and custom defaults in Express edition?

Does it allow you it create rules ? a right click does not present an option, as if you cannot. Going to try T-SQL to see if that works.

John

JohnF wrote:

Does it allow you it create rules ? a right click does not present an option, as if you cannot. Going to try T-SQL to see if that works.

John

No, but only when you want it to make up rules,|||

I see CHECK constraints is the way to go now

|||

Yep,

see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/63e1bd15-d618-4ee4-a819-641137101816.htm or http://msdn2.microsoft.com/en-us/library/ms187615.aspx, they are deprecated.

Jens K. Suessmeyer.

http://www.sqlserver2005.de