Create Instance of Notification Service

Hi,

I am getting the following error.

Event ID:XmlValidationError Source:NSEventStrings

while creating Instance of Notification Service.

Hi,

This is probably becuase your instance definition file or application definition file is not compatible with SQL NS schemas.

Following link contains complete template of instance and application definition file. Make sure your xml adheres to it.

http://msdn2.microsoft.com/en-us/library/ms145917.aspx
http://msdn2.microsoft.com/en-US/library/ms145313.aspx

Shamir

|||As Shamir mentioned, both the ICF and ADF must be well-formed and valid XML documents. They are validated against an XSD schema in your SSNS installation folder.

Keep in mind that XML is case-sensitive.

HTH...

Joe

Create Instance of Notification Service

Hi,

I am getting the following error.

Event ID:

XmlValidationError

Source:

NSEventStrings

while creating Instance of Notification Service.

Hi,

This is probably becuase your instance definition file or application definition file is not compatible with SQL NS schemas.

Following link contains complete template of instance and application definition file. Make sure your xml adheres to it.

http://msdn2.microsoft.com/en-us/library/ms145917.aspx
http://msdn2.microsoft.com/en-US/library/ms145313.aspx

Shamir|||As Shamir mentioned, both the ICF and ADF must be well-formed and valid XML documents. They are validated against an XSD schema in your SSNS installation folder.

Keep in mind that XML is case-sensitive.

HTH...

Joe

Create Instance of Notification Service

Hi,

I am getting the following error.

Event ID:XmlValidationError Source:NSEventStrings

while creating Instance of Notification Service.

Hi,

This is probably becuase your instance definition file or application definition file is not compatible with SQL NS schemas.

Following link contains complete template of instance and application definition file. Make sure your xml adheres to it.

http://msdn2.microsoft.com/en-us/library/ms145917.aspx
http://msdn2.microsoft.com/en-US/library/ms145313.aspx

Shamir

|||As Shamir mentioned, both the ICF and ADF must be well-formed and valid XML documents. They are validated against an XSD schema in your SSNS installation folder.

Keep in mind that XML is case-sensitive.

HTH...

Joe

CREATE DATABASE from Template?

Hello,
I need to be able toCREATE DATABASE by copying an existing database.
I would be doing this inside of a web app during an event.
How do I set this up on SQL 2005 ?

Thanks!

Here's an article on how to do it in PostgreSQL http://www.enterprisedb.com/documentation/manage-ag-templatedbs.htmlSQL Server 2005 has 'Copy Database Wizard' in Management Studio; you can also copy databases with Backup and Restore. But both methods seems not so easier to be done inside of web app during an event. Anyways you can take a look at 'Copying Databases to Other Servers' topic in SQL2005 Books Online.|||What if i made a backup of my "template" db
then had a stored proc like:

create procedure restoredb
@.dbname sysname
as
restore database @.dbname from disk='c:\backup.bak'
with move 'file_data' to 'd:\mssql\mssql\data\' + @.dbname + '_data.mdf',
move 'file_log' to 'd:\mssql\mssql\data\' + @.dbname + '_log.ldf',
replace

that created the new db