Database backup

I tried to backup a database but failed:
In EM, right click Northwind, select All Tasks, Backup a database...
Enter Description, select complete backup, Add a destination to a location,
set the shedule.
But there is not backup after the schedule time.
Anything I missed ?
Check inside Management, SQL Agent, Jobs and see if there is a n error
associated with the job
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:uTPM1$rpEHA.3300@.TK2MSFTNGP12.phx.gbl...
>I tried to backup a database but failed:
> In EM, right click Northwind, select All Tasks, Backup a database...
> Enter Description, select complete backup, Add a destination to a
> location,
> set the shedule.
> But there is not backup after the schedule time.
> Anything I missed ?
>
>
|||Ah, may be the SQL Server Agent has not started.
"Mary Bray" <no@.spam.com> wrote in message
news:%231pAMcspEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Check inside Management, SQL Agent, Jobs and see if there is a n error
> associated with the job
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:uTPM1$rpEHA.3300@.TK2MSFTNGP12.phx.gbl...
>

Database backup

I tried to backup a database but failed:
In EM, right click Northwind, select All Tasks, Backup a database...
Enter Description, select complete backup, Add a destination to a location,
set the shedule.
But there is not backup after the schedule time.
Anything I missed ?Check inside Management, SQL Agent, Jobs and see if there is a n error
associated with the job
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:uTPM1$rpEHA.3300@.TK2MSFTNGP12.phx.gbl...
>I tried to backup a database but failed:
> In EM, right click Northwind, select All Tasks, Backup a database...
> Enter Description, select complete backup, Add a destination to a
> location,
> set the shedule.
> But there is not backup after the schedule time.
> Anything I missed ?
>
>|||Ah, may be the SQL Server Agent has not started.
"Mary Bray" <no@.spam.com> wrote in message
news:%231pAMcspEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Check inside Management, SQL Agent, Jobs and see if there is a n error
> associated with the job
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:uTPM1$rpEHA.3300@.TK2MSFTNGP12.phx.gbl...
> >I tried to backup a database but failed:
> >
> > In EM, right click Northwind, select All Tasks, Backup a database...
> > Enter Description, select complete backup, Add a destination to a
> > location,
> > set the shedule.
> >
> > But there is not backup after the schedule time.
> >
> > Anything I missed ?
> >
> >
> >
>

data types help?

Which data type do I need to assign to my field to let users enter characters such as +=-_|\ etc...pretty much every single character from a standard keyboard...
thanksAny of the CHAR() related types, such as CHAR(), VARCHAR(), NCHAR(), NVARCHAR(), or TEXT should do nicely.

-PatP|||I have varchar now (on a web site with sql server as a database) but only save the letter and number for this example ab+ not the plus...

But I do have function, that I will probably have to customize,that is causing it only to save letters and numbers,

Thanks for your help once again

Data Type that accept . for MSSQL

Hi,

I wish to enter some string data with period(.) in a column with char type. It doesn't accept period(.) What data type should I choose for this field ?

I'm using MSSQL Server 2000.

Please advice.varchar, nvarchar..?|||Thanks.