Back up

Hi all
I am able to get back up VIA Database>All Tasks>Backup Database but I cannot
schedule it for particular time.
May be I am missing something but I tried all options.
Is there any other thing to do.
RegardsHi,
There are 2 options
1. Use Maintenance plan to backup the database. It has the scheduling option
2. Write ur own script and schedule it using SQL agent -- Jobs inside
Enterprise manager
1. Maintenance Plan
1. Open Enterprise maneger, Expand the Management options and select
"database Maintenance Plans"
2. Right click and select new maintenance plan
3. Click Next and select the database u need to backup and click next till
the "Database Backup Plan " screen comes
4. There you can schedule the time for backup and click next
5. In the backup disk directory , you can specify the backup folder and
click next and specify the number of backup copies to keep
6. COntinue the steps (it is prestty easy to understand)
Maintenance plans use SQL agent to schedule so ensure that SQL Agent service
run all the time in the SQL server Machine.
2. SQL Agent schedule
1. In enterprise manager -- select SQL agent - Jobs
2. Right click jobs and create new job
3. Give a name and go to Steps tab and give the TSQL command to backup
(Backup database <dbname> to disk='c:\backup\dbname.bak' with init)
4. Go to schedule tab and schedule atime for backup
Ensure that SQL Agent service run all the time in the SQL server Machine.
Thanks
Hari
MCDBA
"F@.yy@.Z" <fayyaz.ahmed@.mvwebmaker.com> wrote in message
news:#O27QolEEHA.624@.TK2MSFTNGP10.phx.gbl...
> Hi all
>
> I am able to get back up VIA Database>All Tasks>Backup Database but I
cannot
> schedule it for particular time.
> May be I am missing something but I tried all options.
> Is there any other thing to do.
>
> Regards
>|||Thanks Hari

> Ensure that SQL Agent service run all the time in the SQL server Machine
This is the main thing I was missing after running it everything is OK
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23XobD4lEEHA.3344@.tk2msftngp13.phx.gbl...
> Hi,
> There are 2 options
> 1. Use Maintenance plan to backup the database. It has the scheduling
option
> 2. Write ur own script and schedule it using SQL agent -- Jobs inside
> Enterprise manager
> 1. Maintenance Plan
> 1. Open Enterprise maneger, Expand the Management options and select
> "database Maintenance Plans"
> 2. Right click and select new maintenance plan
> 3. Click Next and select the database u need to backup and click next till
> the "Database Backup Plan " screen comes
> 4. There you can schedule the time for backup and click next
> 5. In the backup disk directory , you can specify the backup folder and
> click next and specify the number of backup copies to keep
> 6. COntinue the steps (it is prestty easy to understand)
> Maintenance plans use SQL agent to schedule so ensure that SQL Agent
service
> run all the time in the SQL server Machine.
> 2. SQL Agent schedule
> 1. In enterprise manager -- select SQL agent - Jobs
> 2. Right click jobs and create new job
> 3. Give a name and go to Steps tab and give the TSQL command to backup
> (Backup database <dbname> to disk='c:\backup\dbname.bak' with init)
> 4. Go to schedule tab and schedule atime for backup
> Ensure that SQL Agent service run all the time in the SQL server Machine.
> Thanks
> Hari
> MCDBA
> "F@.yy@.Z" <fayyaz.ahmed@.mvwebmaker.com> wrote in message
> news:#O27QolEEHA.624@.TK2MSFTNGP10.phx.gbl...
> cannot
>

Avoid splitting trees by value missing

Hi, could anyone kindly let me know how to prevent the Decision Trees model from using value missing as a criterion to split trees?

Thanks,

hz

Decision trees only splits on missing if you have sparse data. Are you using nested tables possibly? If not, then you have a column in your table with enough NULLs that are correlated with your target that there is enough information gain to cause a split. You can use NOT NULL, but this will just prevent the model from processing altogether if nulls are present|||

Yes, unfortunately, there are a lot of null values. I am not sure what you mean by "use NOT NULL". I have many predictor columns. Their null values are not in sync. If "NOT NULL" is used as a filter for every predictor, there may be no case left.

|||Unfortunately there's no way to not split by a value that appears in the data in SQL 2005. It's something for us to think about for future versions (expecially the "NULL" case)

Avoid splitting trees by value missing

Hi, could anyone kindly let me know how to prevent the Decision Trees model from using value missing as a criterion to split trees?

Thanks,

hz

Decision trees only splits on missing if you have sparse data. Are you using nested tables possibly? If not, then you have a column in your table with enough NULLs that are correlated with your target that there is enough information gain to cause a split. You can use NOT NULL, but this will just prevent the model from processing altogether if nulls are present|||

Yes, unfortunately, there are a lot of null values. I am not sure what you mean by "use NOT NULL". I have many predictor columns. Their null values are not in sync. If "NOT NULL" is used as a filter for every predictor, there may be no case left.

|||Unfortunately there's no way to not split by a value that appears in the data in SQL 2005. It's something for us to think about for future versions (expecially the "NULL" case)