Our sql box is being replaced due to its age.
So asking the experts, would
backing up the db, removing the box AD, putting the nex sql on AD(same name)
and restore the db to the same instance result in minimal downtime?

I am new to SQL 05 and IIS but we have to install/build a SQL 05 server
(Win03 SBS Premium) for a new internal application but also for an
e-application/portal that will sit on another server with IIS.
What would be the rule of thumb to secure this setup from the Internet.

Folks,
I use Windows XP SP3 and am trying to install Office 2007 Small
Business. Disc 1 installs OK but Disc 2 keeps aborting. The message I
get is:

I am installing default instance of SQL Server 2008 x64 on Windows Vista
Enterprise (x64). I get the warning on windows firewall: rule "Windows
Firewall" generated a warning.
I am including these at the bottom of this post:

    We are installing SQL Server 2005 Developer edition in a Windows VISTA
machine having Visual Studio 2005 Professional Edition with SQL Server
Express Edition 2005.We have the latest service packs for Visual Studio and
SQL Sever.The problem is that we are not able to install ...

I am about to install SQL Server 2008 Developer Edition.  Should I uninstall
the pre-release version (10.0.1300) before installing the new release?
Thanks

I have created SQL server instance in one of the system and getting problem
when I tried to connect server from another PC using SQL server enteprise
manager. (error message : login failed for user(null)).
Right now I'm using Windows only authentication in the SQL server. do I ...

I have created MSDE 2000 database and right now it is reached its maximum
size (2GB). so deleted some of the records and the actual datasize in all
tables is came down to 1GB (I used sp_spaceused to determine this). However
the filesize in the explorer (mydb_data.mdf) is still ...

I has installed sql 2005 std on a windows 2008 server.   I cannot connect
with windows authentication locally from a user that is in the local admin
group.   I can connect with windows authentication from a remote workstation
using a user in the local admin group.  Anyone with ...

Is it possible to rollback transactions for a database.  This is the
situation.  A customer deleted some data from the system that they needed.
They were messing with the purging utility.
Thier IT guy does not have a backup.  He actually is not doing backups to

i am trying to set up SQL Server 2005 Standard on an XP box that used
to have Express Edition until i uninstalled it.  for some reason all
the components install (SSIS, SSAS, etc) except the database engine
and the workstation components.  the setup routine craps out when it's

Hope someone can help me out here. I've had a long running problem with
SQLserver 2005 (Standard, Developers and Express).
When I try to import or export data to or from a database I get the
following message:

I am getting this error message when ever I try to unistall SQL Server
Express and when I try to load the service pack 2 for SQLServer 2005.
I have looked high and low but there isn't a solution.  Please help
me.  I am using Windows Vista by the way.

Not being an SQL Server person, I tried many of the various
suggestions and read many of the pre-requisites for shrinking the
trans log but it isn't working. What many sites I've Googled said was
that you had to make a trans log backup first before a shrink could be

If we purchase 2 Developer Edition licenses, can we install the SQL Server
services on a networked machine and install the SQL Server client on the
developer's machines?  This would allow us to share the same database to
develop our application.