Re: SMS SQL Server Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Because of the SMS_SQL_Monitor service, I think that you can't use any 64
bit OS. I will try to confirm that tomorrow but I think you are out of luck


"Dave Edwards" <DaveEdwards@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FF94CF3-2DBB-4EFB-96AA-4B999EA44180@xxxxxxxxxxxxxxxx
Garth,
These specs refer to the SMS server, I plan to have the database on a
seperate dedicated SQL 2005 Std. 64 Bit server. Is this also not
supported?
--
Regards,

Dave


"Garth" wrote:

Note SMS server roles are not supported on 64-bit operating systems.
http://download.microsoft.com/download/5/c/a/5cab7c25-9dba-4462-a887-1977337e369e/SMS2003SP3SupportedConfigurations.htm


"Dave Edwards" <DaveEdwards@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B67D266B-C341-4889-83D9-BBE1D303B48E@xxxxxxxxxxxxxxxx
Forgot to mentions that SQL 2005 SP2 will be 64 bit on Windows 2003 r2
64
Bit
--
Regards,

Dave


"Stefan Olsson" wrote:

Hello Dave,

First of all SQL 2005 isnt supported on all configurations, what
service
pack level of sms are you on at the moment ?


----------------------------------------
Stefan Olsson
MCSA:Messaging
E-Mail: stefan@xxxxxxxx
www.msfaq.se
-----------------------------------------

Kim, What about moving the database from SQL 2000 to SQL 2005? Are
there any further steps that need to be taken?

Dave

"Kim Oppalfens <MVP>" wrote:

Stop sms services
Backup sql database
restore sql database on new server.
Run sms site reset and point it to a new database.
--
Kim Oppalfens
Telindus Belgium
MVP Windows Server System - SMS
"DC" <DC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DA156CD3-BED3-4129-9F7C-AE0B35B8FB11@xxxxxxxxxxxxxxxx
Hello,

My SMS Server is technically quite suitable but I have a dedicated
SQL Server ofr database hosting and managing.

I have tried to move this database to another server and redefine
my
SMS installation. But it failed.

Does anyone has a valid procedure in order to help me change my
SMS
DB references ? My manager is tracking me ;-).

Thanks to anyone that could provide help.

David









.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: SMS 2003 SP2 and SQL 2000
    ... most likely the issues is related to that you are using "core" SQL functionality to dump the database to the same file every time it back's up the SMS db. ... As Garth did mention you should disable all this SQL Server Agent jobs and rather rely on the SMS_SITE_BACKUP task instead, as it will backup all required components at the same point in time. ...
    (microsoft.public.sms.admin)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)