Database Backup

Hi,

Currently i schedule my SQL sever agent to do database backup once in a few days with the default backup file name to ABC. Hence everytime, it will overwrite the previous file. Is there a way for me to auto append date time at the back of my default file name? Eg will be ABC_DD_MM_YYYY
Thanks!

Regards,
weihann.If you right click your database name, choose all tasks -backup database, you can find what you want.

Data Validation on merge agent

Hi,
I intend to set up data validation and re-initialize on merge agent. But
I'm not sure if it will cause data lost at subscriber side.
If the data validation fail, the merge agent is supposed to re-initialize
the subscriber from last successful data validation. Does it mean any data
change at the subscriber after the specific re-initialization point would
lost?
Please Help
Thanks
Yong
There is an option to upload the subscriber changes before the subscription
is reinitialized. If you use this option you will not lose any subscriber
data.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"yong" <yong@.discussions.microsoft.com> wrote in message
news:8E312D5B-5A2D-494B-A6BE-62E056993DDB@.microsoft.com...
> Hi,
> I intend to set up data validation and re-initialize on merge agent. But
> I'm not sure if it will cause data lost at subscriber side.
> If the data validation fail, the merge agent is supposed to
> re-initialize
> the subscriber from last successful data validation. Does it mean any data
> change at the subscriber after the specific re-initialization point would
> lost?
> Please Help
> Thanks
> Yong
>