Comprehensive data protection for all workloads
Post Reply
ceririch
Novice
Posts: 3
Liked: never
Joined: Apr 20, 2009 9:40 pm
Contact:

Backup v3 and SQL 2000

Post by ceririch »

First post so be gentle!

Is the above compatible/supported to utilise SQL 2000 as its back-end? Noticed in the install notes that only 2005 is mentioned and I got the following error on install -

Product: Veeam Backup and FastSCP -- Error 26204. Error -2147217900: failed to execute SQL string, error detail: Line 12: Incorrect syntax near '('., SQL key: DBcreate.sql SQL string: IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Hosts]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Hosts](
[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Hosts_id] DEFAULT (newid()),
[type] [int] NOT NULL,
[name] [nvarchar](255) NOT NULL,
[ip] [nvarchar](50) NULL,
[parent_id] [uniqueidentifier] NULL,
CONSTRAINT [PK_Hosts] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY],
CONSTRAINT [IX_Hosts] UNIQUE NONCLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

Gostev
SVP, Product Management
Posts: 26701
Liked: 4276 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backup v3 and SQL 2000

Post by Gostev »

Hello, yes - as per system requirements, SQL 2000 is not supported.

ceririch
Novice
Posts: 3
Liked: never
Joined: Apr 20, 2009 9:40 pm
Contact:

Re: Backup v3 and SQL 2000

Post by ceririch »

Thanks!

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot], Majestic-12 [Bot], toshihiro and 33 guests