The goal of this blog is to share my knowledge as a DBA/Developer in SQL Server area. Many years ago I started to collect some tips and tricks from many experts of SQL Server around the world as well as the scripts developed by myself. And I really want to share them with you. Also my intend is to help beginners as well as experienced people such I have been doing at microsoft forums. So please do not hesitate to write me comments or questions.
4 comments:
Mazal tov!!
Toda Saggi
Congratulations!
Can you please look at your blog: Scheduling database backup in SQL 2005 Express Edition
I have posted a question...
Have a nice day,
Vedran Budinski
Vedro
Those commands look OK.Frist of all you copy the data into a new table then you truncate the data.
Since we do not have SQL Agent in Express Edition your optio is to use Scheduled Tasks of Windows. I posted the sample script.
Post a Comment