escaping data for update query

I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?
I'm not using any fancy ado.net objects:
string sql= [whatever the user passes in]
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionString].ToString());
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
try
{
int result = command.ExecuteNonQuery();
if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}
connection.Close();
On 6 4 , 8 48 , eggie5 <egg...@.gmail.com> wrote:
> I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql= [whatever the user passes in]
> SqlConnection connection = new
> SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionStrXing].ToString());
> connection.Open();
> SqlCommand command = connection.CreateCommand();
> command.CommandType = CommandType.Text;
> command.CommandText = sql;
> try
> {
> int result = command.ExecuteNonQuery();
> if (result != 1)
> {
> Response.StatusCode = 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode = 500;
> Response.End();
> }
> connection.Close();
You can string.replace() method to escape
charater ' by ''(double single quotes).
|||If you post the same question to multiple groups, send the message once and
specify all groups (crosspost) rather than post independent messages. This
courtesy allows everyone involved to track the responses and prevents
duplication of effort.

> Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
The Best Practice is to use parameters rather than build a SQL statement
string. Not only does this eliminate the need to escape quotes, it's much
more secure because it's not vulnerable to SQL injection. Simple example
below.
command.CommandText = "INSERT INTO dbo.MyTable VALUES(@.UserParameter)";
SqlParameter param = new SqlParameter("@.UserParameter",
userSuppliedValue);
command.Parameters.Add(param);
command.ExecuteNonQuery();
Hope this helps.
Dan Guzman
SQL Server MVP
"eggie5" <eggie5@.gmail.com> wrote in message
news:1180918088.976008.41270@.q75g2000hsh.googlegro ups.com...
>I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql= [whatever the user passes in]
> SqlConnection connection = new
> SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionString].ToString());
> connection.Open();
> SqlCommand command = connection.CreateCommand();
> command.CommandType = CommandType.Text;
> command.CommandText = sql;
>
> try
> {
> int result = command.ExecuteNonQuery();
> if (result != 1)
> {
> Response.StatusCode = 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode = 500;
> Response.End();
> }
> connection.Close();
>

escaping data for update query

I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?
I'm not using any fancy ado.net objects:
string sql= [whatever the user passes in]
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnectionString].ToString());
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
try
{
int result = command.ExecuteNonQuery();
if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}
connection.Close();On 6 4 , 8 48 , eggie5 <egg...@.gmail.com> wrote:
> I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql=3D [whatever the user passes in]
> SqlConnection connection =3D new
> SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnectionS=tr=ADing].ToString());
> connection.Open();
> SqlCommand command =3D connection.CreateCommand();
> command.CommandType =3D CommandType.Text;
> command.CommandText =3D sql;
> try
> {
> int result =3D command.ExecuteNonQuery();
> if (result !=3D 1)
> {
> Response.StatusCode =3D 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode =3D 500;
> Response.End();
> }
> connection.Close();
You can string.replace() method to escape
charater ' by ''(double single quotes).|||If you post the same question to multiple groups, send the message once and
specify all groups (crosspost) rather than post independent messages. This
courtesy allows everyone involved to track the responses and prevents
duplication of effort.
> Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
The Best Practice is to use parameters rather than build a SQL statement
string. Not only does this eliminate the need to escape quotes, it's much
more secure because it's not vulnerable to SQL injection. Simple example
below.
command.CommandText = "INSERT INTO dbo.MyTable VALUES(@.UserParameter)";
SqlParameter param = new SqlParameter("@.UserParameter",
userSuppliedValue);
command.Parameters.Add(param);
command.ExecuteNonQuery();
--
Hope this helps.
Dan Guzman
SQL Server MVP
"eggie5" <eggie5@.gmail.com> wrote in message
news:1180918088.976008.41270@.q75g2000hsh.googlegroups.com...
>I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql= [whatever the user passes in]
> SqlConnection connection = new
> SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnectionString].ToString());
> connection.Open();
> SqlCommand command = connection.CreateCommand();
> command.CommandType = CommandType.Text;
> command.CommandText = sql;
>
> try
> {
> int result = command.ExecuteNonQuery();
> if (result != 1)
> {
> Response.StatusCode = 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode = 500;
> Response.End();
> }
> connection.Close();
>

escaping data for update query

I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?
I'm not using any fancy ado.net objects:
string sql= [whatever the user passes in]
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnection
String].ToString());
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
try
{
int result = command.ExecuteNonQuery();
if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}
connection.Close();On 6 4 , 8 48 , eggie5 <egg...@.gmail.com> wrote:
> I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql=3D [whatever the user passes in]
> SqlConnection connection =3D new
> SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnectionS=[/vb
col]
tr=ADing].ToString());[vbcol=seagreen]
> connection.Open();
> SqlCommand command =3D connection.CreateCommand();
> command.CommandType =3D CommandType.Text;
> command.CommandText =3D sql;
> try
> {
> int result =3D command.ExecuteNonQuery();
> if (result !=3D 1)
> {
> Response.StatusCode =3D 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode =3D 500;
> Response.End();
> }
> connection.Close();
You can string.replace() method to escape
charater ' by ''(double single quotes).|||If you post the same question to multiple groups, send the message once and
specify all groups (crosspost) rather than post independent messages. This
courtesy allows everyone involved to track the responses and prevents
duplication of effort.

> Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
The Best Practice is to use parameters rather than build a SQL statement
string. Not only does this eliminate the need to escape quotes, it's much
more secure because it's not vulnerable to SQL injection. Simple example
below.
command.CommandText = "INSERT INTO dbo.MyTable VALUES(@.UserParameter)";
SqlParameter param = new SqlParameter("@.UserParameter",
userSuppliedValue);
command.Parameters.Add(param);
command.ExecuteNonQuery();
Hope this helps.
Dan Guzman
SQL Server MVP
"eggie5" <eggie5@.gmail.com> wrote in message
news:1180918088.976008.41270@.q75g2000hsh.googlegroups.com...
>I have some code (C#) that runs an SQL update query that sets the
> value of a column to what the user passes. So, this causes an error
> when anything the user passes in has a ' character in it. I'm sure
> there's other characters that'll break it too. So, I was wondering,
> how do I get around this? Is there some commonly accepted regex
> pattern that will make the value safe to run in an SQL query? How can
> I take care of any values that need to be escaped?
> I'm not using any fancy ado.net objects:
> string sql= [whatever the user passes in]
> SqlConnection connection = new
> SqlConnection(ConfigurationManager.ConnectionStrings[Utils.GetConnecti
onString].ToString());
> connection.Open();
> SqlCommand command = connection.CreateCommand();
> command.CommandType = CommandType.Text;
> command.CommandText = sql;
>
> try
> {
> int result = command.ExecuteNonQuery();
> if (result != 1)
> {
> Response.StatusCode = 500;
> Response.Write("The file has been uploaded, but we
> could not update the DB");
> Response.End();
> }
> }
> catch (InvalidOperationException)
> {
> Response.Clear();
> Response.Write("error");
> Response.StatusCode = 500;
> Response.End();
> }
> connection.Close();
>

escaping data for update query

I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?

I'm not using any fancy ado.net objects:

string sql= [whatever the user passes in]

SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionString].ToString());
connection.Open();

SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;

try
{
int result = command.ExecuteNonQuery();

if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}

connection.Close();If you post the same question to multiple groups, send the message once and
specify all groups (crosspost) rather than post independent messages. This
courtesy allows everyone involved to track the responses and prevents
duplication of effort.

This question has been answered in both microsoft.public.sqlserver.server
and microsoft.public.sqlserver.programming.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"eggie5" <eggie5@.gmail.comwrote in message
news:1180917930.810194.38600@.q75g2000hsh.googlegro ups.com...

Quote:

Originally Posted by

>I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?
>
I'm not using any fancy ado.net objects:
>
string sql= [whatever the user passes in]
>
SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionString].ToString());
connection.Open();
>
SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;
>
>
try
{
int result = command.ExecuteNonQuery();
>
if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}
>
connection.Close();
>

|||oops sorry!

On Jun 3, 8:18 pm, "Dan Guzman" <guzma...@.nospam-online.sbcglobal.net>
wrote:

Quote:

Originally Posted by

If you post the same question to multiple groups, send the message once and
specify all groups (crosspost) rather than post independent messages. This
courtesy allows everyone involved to track the responses and prevents
duplication of effort.
>
This question has been answered in both microsoft.public.sqlserver.server
and microsoft.public.sqlserver.programming.
>
--
Hope this helps.
>
Dan Guzman
SQL Server MVP
>
"eggie5" <egg...@.gmail.comwrote in message
>
news:1180917930.810194.38600@.q75g2000hsh.googlegro ups.com...
>

Quote:

Originally Posted by

I have some code (C#) that runs an SQL update query that sets the
value of a column to what the user passes. So, this causes an error
when anything the user passes in has a ' character in it. I'm sure
there's other characters that'll break it too. So, I was wondering,
how do I get around this? Is there some commonly accepted regex
pattern that will make the value safe to run in an SQL query? How can
I take care of any values that need to be escaped?

>

Quote:

Originally Posted by

I'm not using any fancy ado.net objects:

>

Quote:

Originally Posted by

string sql= [whatever the user passes in]

>

Quote:

Originally Posted by

SqlConnection connection = new
SqlConnection(ConfigurationManager.ConnectionStrin gs[Utils.GetConnectionStr ing].ToString());
connection.Open();

>

Quote:

Originally Posted by

SqlCommand command = connection.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = sql;

>

Quote:

Originally Posted by

try
{
int result = command.ExecuteNonQuery();

>

Quote:

Originally Posted by

if (result != 1)
{
Response.StatusCode = 500;
Response.Write("The file has been uploaded, but we
could not update the DB");
Response.End();
}
}
catch (InvalidOperationException)
{
Response.Clear();
Response.Write("error");
Response.StatusCode = 500;
Response.End();
}

>

Quote:

Originally Posted by

connection.Close();

errors whan running backup plan

My event log has the following entries every day ( because the plan runs every
day)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels Backup
Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by Schedule
20 (Schedule 1). The last step to run was step 1 (Step 1).
That error message follows four other entries like this.
Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump devices:
1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
I seem to have all the backups in the folder that there should be, but then what
is happening with the first error message?
I also can manually make a backup without any error messages appearing so
something is wrong with my plan but what? it doesn't look that complicated to
set up.Do you have any other steps on this maintenance plan such as an integrity
check?
Jim
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Do you get any better errormessages if you specify a report file for the
plan and check that report file?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
> Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Ahh that was helpful.
here is what I get:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
...
So I removed the system databases leaving only my database from the backup
and it went fine. do I need to save the system databases differently? or at
all?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Do you get any better errormessages if you specify a report file for the
> plan and check that report file?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <mmac@.junkmail.bin> wrote in message
> news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > My event log has the following entries every day ( because the plan runs
> every
> > day)
> >
> > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
'Michaels
> Backup
> > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
on:
> > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> Schedule
> > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> >
> > That error message follows four other entries like this.
> >
> > Database backed up: Database: model, creation date(time):
> 2000/08/06(01:40:52),
> > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> devices:
> > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
> SQL
> > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> >
> > I seem to have all the backups in the folder that there should be, but
> then what
> > is happening with the first error message?
> > I also can manually make a backup without any error messages appearing
so
> > something is wrong with my plan but what? it doesn't look that
complicated
> to
> > set up.
> >
> >
>|||> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
Yes, create a different maint pan for master, model and msdb and do backup
once a day... :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <no@.thanks.com> wrote in message
news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> Ahh that was helpful.
> here is what I get:
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs
to
> be in single user mode.
> ...
> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > Do you get any better errormessages if you specify a report file for the
> > plan and check that report file?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <mmac@.junkmail.bin> wrote in message
> > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > My event log has the following entries every day ( because the plan
runs
> > every
> > > day)
> > >
> > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Michaels
> > Backup
> > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> on:
> > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > Schedule
> > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > >
> > > That error message follows four other entries like this.
> > >
> > > Database backed up: Database: model, creation date(time):
> > 2000/08/06(01:40:52),
> > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > devices:
> > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
Files\Microsoft
> > SQL
> > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > >
> > > I seem to have all the backups in the folder that there should be, but
> > then what
> > > is happening with the first error message?
> > > I also can manually make a backup without any error messages appearing
> so
> > > something is wrong with my plan but what? it doesn't look that
> complicated
> > to
> > > set up.
> > >
> > >
> >
> >
>|||and they will backup in "single user mode"?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> Yes, create a different maint pan for master, model and msdb and do backup
> once a day... :-)
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "mmac" <no@.thanks.com> wrote in message
> news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > Ahh that was helpful.
> > here is what I get:
> >
> >
> > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
> > 'MASTER'.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> > [1] Database master: Check Data and Index Linkage...
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL
> > Server Driver][SQL Server]Repair statement not processed. Database needs
> to
> > be in single user mode.
> > ...
> > So I removed the system databases leaving only my database from the
> backup
> > and it went fine. do I need to save the system databases differently? or
> at
> > all?
> >
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > Do you get any better errormessages if you specify a report file for the
> > > plan and check that report file?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at:
> > >
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > My event log has the following entries every day ( because the plan
> runs
> > > every
> > > > day)
> > > >
> > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > 'Michaels
> > > Backup
> > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
> > on:
> > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
> > > Schedule
> > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > >
> > > > That error message follows four other entries like this.
> > > >
> > > > Database backed up: Database: model, creation date(time):
> > > 2000/08/06(01:40:52),
> > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
> > > devices:
> > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> Files\Microsoft
> > > SQL
> > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > >
> > > > I seem to have all the backups in the folder that there should be, but
> > > then what
> > > > is happening with the first error message?
> > > > I also can manually make a backup without any error messages appearing
> > so
> > > > something is wrong with my plan but what? it doesn't look that
> > complicated
> > > to
> > > > set up.
> > > >
> > > >
> > >
> > >
> >
> >
>|||There's no need to set the single user mode unless you check the dreaded
"Attempt to repair minor problems" under the integrity check part. I do not
recommend using this option at all. If I have a problem with a corrupt
database, I want to know that.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:uy7MGro$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> and they will backup in "single user mode"?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> >
> > Yes, create a different maint pan for master, model and msdb and do
backup
> > once a day... :-)
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "mmac" <no@.thanks.com> wrote in message
> > news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> > > Ahh that was helpful.
> > > here is what I get:
> > >
> > >
> > > Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
Server
> > > 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> > > Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30
PM
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in
database
> > > 'MASTER'.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
failed.
> > > [1] Database master: Check Data and Index Linkage...
> > > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919:
[Microsoft][ODBC
> > SQL
> > > Server Driver][SQL Server]Repair statement not processed. Database
needs
> > to
> > > be in single user mode.
> > > ...
> > > So I removed the system databases leaving only my database from the
> > backup
> > > and it went fine. do I need to save the system databases differently?
or
> > at
> > > all?
> > >
> > >
> > >
> > > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in
> > > message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> > > > Do you get any better errormessages if you specify a report file for
the
> > > > plan and check that report file?
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at:
> > > >
> > >
> >
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> > > >
> > > >
> > > > "mmac" <mmac@.junkmail.bin> wrote in message
> > > > news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> > > > > My event log has the following entries every day ( because the
plan
> > runs
> > > > every
> > > > > day)
> > > > >
> > > > > SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> > > 'Michaels
> > > > Backup
> > > > > Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed -
Invoked
> > > on:
> > > > > 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked
by
> > > > Schedule
> > > > > 20 (Schedule 1). The last step to run was step 1 (Step 1).
> > > > >
> > > > > That error message follows four other entries like this.
> > > > >
> > > > > Database backed up: Database: model, creation date(time):
> > > > 2000/08/06(01:40:52),
> > > > > pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of
dump
> > > > devices:
> > > > > 1, device information: (FILE=1, TYPE=DISK: {'C:\Program
> > Files\Microsoft
> > > > SQL
> > > > > Server\MSSQL\BACKUP\model_db_200402110200.BAK'}).
> > > > >
> > > > > I seem to have all the backups in the folder that there should be,
but
> > > > then what
> > > > > is happening with the first error message?
> > > > > I also can manually make a backup without any error messages
appearing
> > > so
> > > > > something is wrong with my plan but what? it doesn't look that
> > > complicated
> > > > to
> > > > > set up.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

errors whan running backup plan

My event log has the following entries every day ( because the plan runs eve
ry
day)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels Ba
ckup
Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by Schedu
le
20 (Schedule 1). The last step to run was step 1 (Step 1).
That error message follows four other entries like this.
Database backed up: Database: model, creation date(time): 2000/08/06(01:40:5
2),
pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump device
s:
1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft
SQL
Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
I seem to have all the backups in the folder that there should be, but then
what
is happening with the first error message?
I also can manually make a backup without any error messages appearing so
something is wrong with my plan but what? it doesn't look that complicated t
o
set up.Do you have any other steps on this maintenance plan such as an integrity
check?
Jim
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft[/colo
r]
SQL
> Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Do you get any better errormessages if you specify a report file for the
plan and check that report file?
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> My event log has the following entries every day ( because the plan runs
every
> day)
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels
Backup
> Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on:
> 2004-02-11 02:00:00 - Message: The job failed. The Job was invoked by
Schedule
> 20 (Schedule 1). The last step to run was step 1 (Step 1).
> That error message follows four other entries like this.
> Database backed up: Database: model, creation date(time):
2000/08/06(01:40:52),
> pages dumped: 91, first LSN: 5:22:1, last LSN: 5:24:1, number of dump
devices:
> 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft[/colo
r]
SQL
> Server\MSSQL\BACKUP\model_db_20040211020
0.BAK'}).
> I seem to have all the backups in the folder that there should be, but
then what
> is happening with the first error message?
> I also can manually make a backup without any error messages appearing so
> something is wrong with my plan but what? it doesn't look that complicated
to
> set up.
>|||Ahh that was helpful.
here is what I get:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in database
'MASTER'.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption comma
nd failed.
[1] Database master: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs
to
be in single user mode.
...
So I removed the system databases leaving only my database from the backup
and it went fine. do I need to save the system databases differently? or at
all?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
> Do you get any better errormessages if you specify a report file for the
> plan and check that report file?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=...ublic.sqlserver
>
> "mmac" <mmac@.junkmail.bin> wrote in message
> news:u84PwfC$DHA.1464@.tk2msftngp13.phx.gbl...
> every
'Michaels
> Backup
on:
> Schedule
> 2000/08/06(01:40:52),
> devices:
> SQL
> then what
so
complicated
> to
>|||> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
Yes, create a different maint pan for master, model and msdb and do backup
once a day... :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <no@.thanks.com> wrote in message
news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> Ahh that was helpful.
> here is what I get:
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'MYSERVER' as 'NT AUTHORITY\SYSTEM' (trusted)
> Starting maintenance plan 'Michaels Backup Plan' on 2/27/2004 12:08:30 PM
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5058: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Option 'SINGLE_USER' cannot be set in databa
se
> 'MASTER'.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption com
mand failed.
> [1] Database master: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODB
C
SQL
> Server Driver][SQL Server]Repair statement not processed. Database needs[/colo
r]
to
> be in single user mode.
> ...
> So I removed the system databases leaving only my database from the
backup
> and it went fine. do I need to save the system databases differently? or
at
> all?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:um0i$ME$DHA.2808@.TK2MSFTNGP10.phx.gbl...
>
http://groups.google.com/groups?oi=...ublic.sqlserver
runs
> 'Michaels
> on:
Files\Microsoft
> so
> complicated
>|||and they will backup in "single user mode"?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
> backup
> at
> Yes, create a different maint pan for master, model and msdb and do backup
> once a day... :-)
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
>
> "mmac" <no@.thanks.com> wrote in message
> news:eByJn9X$DHA.320@.TK2MSFTNGP10.phx.gbl...
> SQL
> SQL
> to
> backup
> at
> in
> [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url
]
> runs
> Files\Microsoft
>|||There's no need to set the single user mode unless you check the dreaded
"Attempt to repair minor problems" under the integrity check part. I do not
recommend using this option at all. If I have a problem with a corrupt
database, I want to know that.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"mmac" <mmac@.junkmail.bin> wrote in message
news:uy7MGro$DHA.2212@.TK2MSFTNGP10.phx.gbl...
> and they will backup in "single user mode"?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> message news:OUnYqaf$DHA.688@.tk2msftngp13.phx.gbl...
or
backup
http://groups.google.com/groups?oi=...ublic.sqlserver
Server
PM
[Microsoft][ODBC
database
failed.
[Microsoft][ODBC
needs
or
wrote
the
http://groups.google.com/groups?oi=...ublic.sqlserver
plan
Invoked
by
dump
but
appearing
>

Errors in SQL Server 2005 Profiler

I notice this running the SQL Server Profiler under the application name Report Server. Every time it runs, it reports an error (in the Error field of Profiler). Does anyone know what this is?

declare @.p1 nvarchar(64)
set @.p1=NULL
exec GetDBVersion @.DBVersion=@.p1 output
select @.p1

Do you mean when running Reporting Service (or just an application named Report Server?), you found errors with the statements you post? If you're talking about Reporting Service, take a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277072&SiteId=1

To understand the error, you may take a look at:

http://msdn2.microsoft.com/en-us/library/aa256379(SQL.80).aspx

ErrorCode=(288)Attempt to release mutex not owned by caller

I keep getting Critical application Errors every night right at the start of
the scheduled NTbackup. It happens right when the SBS Backup runs @. 11PM.
This is the SQL Server 2005 Workgroup edition that comes with SBS Premium.
During installation, they had
me upgrade the Sharepoint Database to the 2005 version for Full-Test
searching. I went through the process w/o error.
I installed the MS Hotfix but the errors still show up.
Here's all the event log
entries that appear at this exact time during backup:
Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2001
Date: 8/13/2007
Time: 11:00:44 PM
User: N/A
Computer: SBSERVER1
Description:
wins (2456) Shadow copy 1 freeze started.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
Event Type: Information
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 3197
Date: 8/13/2007
Time: 11:00:44 PM
User: NT AUTHORITY\SYSTEM
Computer: SBSERVER1
Description:
I/O is frozen on database model. No user action is required. However, if I/O
is not resumed promptly, you could cancel the backup.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7d 0c 00 00 0a 00 00 00 }......
0008: 15 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 45 00 52 00 56 00 S.E.R.V.
0018: 45 00 52 00 31 00 5c 00 E.R.1.\.
0020: 53 00 48 00 41 00 52 00 S.H.A.R.
0028: 45 00 50 00 4f 00 49 00 E.P.O.I.
0030: 4e 00 54 00 00 00 06 00 N.T....
0038: 00 00 6d 00 6f 00 64 00 ..m.o.d.
0040: 65 00 6c 00 00 00 e.l...
-----
============================================ ***The above message is the same for all the db's...about 7***
============================================ Event Type: Information
Event Source: ESENT
Event Category: ShadowCopy
Event ID: 2003
Date: 8/13/2007
Time: 11:00:46 PM
User: N/A
Computer: SBSERVER1
Description:
wins (2456) Shadow copy 1 freeze stopped.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date: 8/13/2007
Time: 11:00:46 PM
User: N/A
Computer: SBSERVER1
Description:
SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex).
ErrorCode=(288)Attempt to release mutex not owned by caller.
. Process=2256. Thread=3220. Client. Instance=SBSMONITORING. VD=.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp
----
It seems to be related to the SBSMONITORING DB's.
Please help. I'm at a loss.
-JoeFWe had a similar problem when backing up databases. Some process had not
released the mutex tables and we ending up restating the server in order to
free it. Hopefully doing this might help you.
If this is not an option download Process Explorer from sysinternals to
see if it can pinpoint the problem. You may be able to free the process
preventing backups,
"JoeF" wrote:
> I keep getting Critical application Errors every night right at the start of
> the scheduled NTbackup. It happens right when the SBS Backup runs @. 11PM.
> This is the SQL Server 2005 Workgroup edition that comes with SBS Premium.
> During installation, they had
> me upgrade the Sharepoint Database to the 2005 version for Full-Test
> searching. I went through the process w/o error.
> I installed the MS Hotfix but the errors still show up.
> Here's all the event log
> entries that appear at this exact time during backup:
> Event Type: Information
> Event Source: ESENT
> Event Category: ShadowCopy
> Event ID: 2001
> Date: 8/13/2007
> Time: 11:00:44 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> wins (2456) Shadow copy 1 freeze started.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> Event Type: Information
> Event Source: MSSQL$SHAREPOINT
> Event Category: (2)
> Event ID: 3197
> Date: 8/13/2007
> Time: 11:00:44 PM
> User: NT AUTHORITY\SYSTEM
> Computer: SBSERVER1
> Description:
> I/O is frozen on database model. No user action is required. However, if I/O
> is not resumed promptly, you could cancel the backup.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 7d 0c 00 00 0a 00 00 00 }......
> 0008: 15 00 00 00 53 00 42 00 ...S.B.
> 0010: 53 00 45 00 52 00 56 00 S.E.R.V.
> 0018: 45 00 52 00 31 00 5c 00 E.R.1.\.
> 0020: 53 00 48 00 41 00 52 00 S.H.A.R.
> 0028: 45 00 50 00 4f 00 49 00 E.P.O.I.
> 0030: 4e 00 54 00 00 00 06 00 N.T....
> 0038: 00 00 6d 00 6f 00 64 00 ..m.o.d.
> 0040: 65 00 6c 00 00 00 e.l...
> -----
> ============================================> ***The above message is the same for all the db's...about 7***
> ============================================> Event Type: Information
> Event Source: ESENT
> Event Category: ShadowCopy
> Event ID: 2003
> Date: 8/13/2007
> Time: 11:00:46 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> wins (2456) Shadow copy 1 freeze stopped.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> Event Type: Error
> Event Source: SQLVDI
> Event Category: None
> Event ID: 1
> Date: 8/13/2007
> Time: 11:00:46 PM
> User: N/A
> Computer: SBSERVER1
> Description:
> SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex).
> ErrorCode=(288)Attempt to release mutex not owned by caller.
> . Process=2256. Thread=3220. Client. Instance=SBSMONITORING. VD=.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> ----
> It seems to be related to the SBSMONITORING DB's.
> Please help. I'm at a loss.
> -JoeF

Error: Subreport could not be shown.

I have a problem with a report containing a number of subreports not running successfully when deployed to the Report Server.

The report runs successfully every time in the VS Development environment, so parameters are all setup correctly and the result is as expected accross the whole report.

No errors or warnings are listed when building or deploying.

All subreports are in the same project as the main report and deployed to the same folder in Report Manager. All the individual subreports run successfully both in VS Studio (Preview Tab) and in the Report Manager portal.

About 50% of the time, the main report runs but shows the error "Subreport could not be shown" for some or all of the subreports.

Running SQL 2005 SP1

Please advise.

Are any of the reports/subreports set to execute on a schedule or are cached?

and do they all have credentials stored?

|||

Thanks for the reply.

None of the reports are cached.|||

Hi,

Can you be experiencing a parameter passing problem? Dates are always a little bit problemetic.

For one of my reports which I use date parameters and the date picker control of the SSRS 2005, the case is just the opposite. It fails on the VS2005 IDE, but runs successfully on the deployed Report Server.

Eralper

http://www.kodyaz.com

|||

Hi,

I don't think this is the issue, because all the subreports are driven by the same 3 parameters from the parent report, 2 of which are using the date picker control and it always works fine in VS. All of the subreports when run individually using the same parameters work fine.

Also, when it returns an error, which is only around half the time, generally the first 1 or 2 of 6 subreports is rendered correctly with the rest showing the error. I have reconciled the data results which are filtered by the parameters (Start & End dates) and the parameters are being correctly applied.

FYI, each subreport takes around 5 minutes to run individually, with the parent report averaging around 15-25 mins.

As a test, I deleted all the reports from the portal, rebuilt the solution and redeployed and everything was working as expected for several runs of the report including a snapshot via a linked report. Unfortunately, the problem has now re-occurred for no apparent reason.

I am begging to suspect resource related / timeout issues or some deloyment related issues but don't really understand why the report would be reliable in VS and not in the portal.

Any help appreciated.

PS: Re your experience, if you haven't already done so, refresh the datasets in VS then try previewing the report.