Problem with Back Up

I have a database I would like to setup auto backup.
More exact it has been set up.
All I want is to change the Destiantion and Schedule.
I remove old destination and establish new one.
Then setup the schedule and press OK.
Next time I check backup properties it has old destiantion.
And doesn't have any schedule.
Could anybody suggest me the means of solving this kind of
problem.
Thank you before.
Alexey,
How is this set up? In a maintenance plan or a SQL Agent job? If a job,
what commands do you have in your job?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Alexey Zhilenko wrote:
> I have a database I would like to setup auto backup.
> More exact it has been set up.
> All I want is to change the Destiantion and Schedule.
> I remove old destination and establish new one.
> Then setup the schedule and press OK.
> Next time I check backup properties it has old destiantion.
> And doesn't have any schedule.
> Could anybody suggest me the means of solving this kind of
> problem.
> Thank you before.
sql

Problem with Back Up

I have a database I would like to setup auto backup.
More exact it has been set up.
All I want is to change the Destiantion and Schedule.
I remove old destination and establish new one.
Then setup the schedule and press OK.
Next time I check backup properties it has old destiantion.
And doesn't have any schedule.
Could anybody suggest me the means of solving this kind of
problem.
Thank you before.Alexey,
How is this set up? In a maintenance plan or a SQL Agent job? If a job,
what commands do you have in your job?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Alexey Zhilenko wrote:
> I have a database I would like to setup auto backup.
> More exact it has been set up.
> All I want is to change the Destiantion and Schedule.
> I remove old destination and establish new one.
> Then setup the schedule and press OK.
> Next time I check backup properties it has old destiantion.
> And doesn't have any schedule.
> Could anybody suggest me the means of solving this kind of
> problem.
> Thank you before.

Problem with Back Up

I have a database I would like to setup auto backup.
More exact it has been set up.
All I want is to change the Destiantion and Schedule.
I remove old destination and establish new one.
Then setup the schedule and press OK.
Next time I check backup properties it has old destiantion.
And doesn't have any schedule.
Could anybody suggest me the means of solving this kind of
problem.
Thank you before.Alexey,
How is this set up? In a maintenance plan or a SQL Agent job? If a job,
what commands do you have in your job?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Alexey Zhilenko wrote:
> I have a database I would like to setup auto backup.
> More exact it has been set up.
> All I want is to change the Destiantion and Schedule.
> I remove old destination and establish new one.
> Then setup the schedule and press OK.
> Next time I check backup properties it has old destiantion.
> And doesn't have any schedule.
> Could anybody suggest me the means of solving this kind of
> problem.
> Thank you before.

Problem with &

Hai

Iam using asp.net 2.0 with sql server 2005 as back end..

i need to pass the data to stored procedure via parameter containg (&) symbol

for ex:

If i pass string like "sample&ss"

it gives the error xml parsing how to avoid this..welcome for your suggestion.

Regards

Senthil

hi,

ampersand doesn't seems to cause an error on Sql server as the statement below

executes succesfully

select 'sample&ss'

I think the error happens in dot net since

where & is an operator such as

a$='xxx'&'yyy'

regards,

joey

|||

If the error is in parsing XML try this: "sample&ss"

'&' is a special character in XML, and if you catually want to use it you need to represent it as &

|||Or...use ASCII...it works all the time sql

Problem Using Copy Database Wizard in SSMS

I am having a problem copying a database on a server back to the same server
from a remote computer using SSMS. I have 2 remote computers (WinXP) running
SSMS on the same domain as the server. I log in as an administrative user on
both, but can only run the Copy Database Wizard successfully from one of the
remote computers.
On the computer that fails, it does so at the Create Package step and
returns an error message saying "No description found". Anyone have an idea
how I should begin troubleshooting this problem? I can not find anything in
the event logs on the remote system or server that sheds a clue, or in the
SQL server logs.
Don Sivitz (DonSivitz@.discussions.microsoft.com) writes:
> I am having a problem copying a database on a server back to the same
> server from a remote computer using SSMS. I have 2 remote computers
> (WinXP) running SSMS on the same domain as the server. I log in as an
> administrative user on both, but can only run the Copy Database Wizard
> successfully from one of the remote computers.
> On the computer that fails, it does so at the Create Package step and
> returns an error message saying "No description found". Anyone have an
> idea how I should begin troubleshooting this problem? I can not find
> anything in the event logs on the remote system or server that sheds a
> clue, or in the SQL server logs.
That's not an error that I've seen. Which method are you trying to use?
Direct copy of the files, or the SMO method?
There is a CTP of SP2 out, and Microsoft claims that there are a lot of
fixes to the Copy Database Wizard. I have not tested it myself, though,
yet. I don't really want to recommend you to install beta software, but
if you are desperate you can try it.
However, there plenty of other ways of achieving what the wizard does,
so you may want to explore those options instead.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx