I've been trying to nail down a simple backup strategy for small
businesses, and having quite a tough time of it.  Nowhere do I seem to be
able to find a concise description of simple, complete automatic daily SQL
Server 2000 backups.

Hi all, I have a few questions on installing SQL 2005 RTM from MSDN
Subscribers:-
1. I have a box that was running Sept CTP of SQL Server. Are there any
specific un-install instructions before I can install RTM? What about the

Guys,
The company bought 10 client RTM license in 2000 and recently I've upgraded
installation to SP3a (I'm new here). There are several databases in that
environment and number of connections are growing. When I issue select

i'm trying to upgrade my CTP version of 2005 to RTM, but i'm getting
error, telling me that setup found some pieces of previous betas.
TIA

I have a database on a secured server that I would like to have automatically
backed up.  The problem is, this database must be backed up into a folder
with very limited access.  What user name/id must be given in the security
properties of the folder to allow the sql agent to ...

Hi Tim,
You can hit ignore to the message and everything should continue to work as expected.
Dan
-----Original Message-----

Are there any limitations to the developer edition of SQL 2005?  I run my
Visual studio development setup on a Win 2003 standard server so I can have
the full features of IIS.  Will the developer edition install on it.  Also,
is there a limit to the number of concurrent ...

I have a problem when restorig a database back up file, i got this error
message:
"The back set in file'C:\file.BAK' was created by BACKUP LOG and cannot be
used for this restore operation.

hey all,
i've done this before but now i'm having problems connecting to sqlexpress
2005 that on a virtual pc. i'm trying to connect to it using enterprise
manager on my host machine. i can ping both ways and have enabled the

Did anyone see this for Reporting Services while installing SQL 2005
Developer?
Machine         : RSERVEW20031
Product         : Microsoft SQL Server 2005 Reporting Services

I've not been able to get the DVD image to install correctly.  It goes
through the first few steps and then fails on installation of the Native
Client.  Then, it continues and finishes the install without installing
database services, reporting services or integration services.  ...

I just installed MS SQL server 2000 onmy laptop for school.
I though all went well, but, I can't seem to start the service.
Can anybody be gentle and explain how I can get this thing to work?
Thanks

Are there any limitations to the developer edition of SQL 2005?  I run my
Visual studio development setup on a Win 2003 standard server so I can have
the full features of IIS.  Will the developer edition install on it.  Also,
is there a limit to the number of concurrent ...

Have a Windows Server 2003 Standard system (Build 3790 SP1) with SQL Server
2000 Standard SP4 (8.00.2039) installed.  Two SQL Server 2000 SP4 instances
are installed on this node in a single OS instance.  Both instances of SQL
Server start and run fine, but the SQL Server Agent ...

I have a SQL Server 2k running SP4 installed on a Windows 2k3 server. It has
two named instances, because the server also runs Veritas Backup Exec, which
itself, installs an instance of SQL Server to log it's actions. This server
is remotely managed by myself.