July 28, 2013 at 3:40 am
Hi
Somebody installed SQL and I am trying to set up a back up job but I dont see a maintenance plan folder under Management. How do I get that installed?
Is it true that the Express edition doesnt come with a backup/maintenance plan option?
Version is: Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Also I read in some forum the following query and running this returns no records:
Use msdb;
Select SP.name, SP.folderid, SPF.parentfolderid, SPF.foldername
From dbo.sysssispackages SP
Left Join dbo.sysssispackagefolders SPF On SP.folderid = SPF.folderid
Where SP.packagetype = 6;
July 28, 2013 at 2:38 pm
That is correct. Database maintenance plans are basically SSIS packages that depend on the SQL Server Agent in order schedule and run the plans. The SQL Server Agent and most SSIS features are not a part of Express Edition.
Additionally, if SSIS packages and maintenance plans cannot be created on an Express instance it would make sense that the query against a SSIS metadata table would return no rows.
Features Supported by the Editions of SQL Server 2012
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply