How to Automate SQL Server Express backups

Подписаться 34 тыс.

Просмотров 77 тыс.

50% 1

Microsoft SQL Server Express editions doesn't have any schedule either jobs for maintenance plans because the SQL Server Agent component is not included in these editions. So, you have to take a different approach to backup your databases when you use these Express editions.
In this video tutorial you are going to learn how to Automate SQL Server express backups using the sql server stored procedure, task scheduler and batch file.
Download: www.itcoh.com/p/download.html
Source: support.microsoft.com/kb/2019698

Опубликовано:

2 фев 2013

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 142

@SachinSamy 11 лет назад

HI there, = If You Like This Video, Give It a Thumbs Up :) = Subscribe to receive email updates when we post new videos ;) , = Share it with your technical IT friends "_" , = if your facing? any technical problem or have any suggestion post your comment here or catch me on google+ or Gtalk :D!

@SachinSamy 11 лет назад

Hey Sandro, That's wonderful. Thanks for watching the video, keep watching and keep leaning :D!

@imronwira 4 года назад

This tutorial is very clear and helpful, there are configuration files that you set and shared, success is always for you

@SachinSamy 10 лет назад

Hey Gowda, thanks for watching the video.Well I am sure if you will search on Google you can find so many tutorials on how to create a tables and database in sql server 2012 :)

@SachinSamy 10 лет назад

Hey Anish, thanks for watching the video See Ya :)

@markwilliams9771 7 лет назад

Just press Ctr + Shift + F after selecting the parameters for your back up in Management Studio and save the script to a sql file in your documents folder. Then run sqlcmd from the Windows Scheduler and call your sql file. It's that simple.

@SachinSamy 11 лет назад

Hi koshaugh, thanks for watching the video See Ya :)

@nilkantdeshpande9461 7 лет назад

Hey sachin how can i change the location of my back up file. i dont want to store the backed up file in c drive.

@SachinSamy 10 лет назад

Hey Marie, yes this also works on SQL express 2008 and Windows Server 2008 R2. Let me now if you have any problem See Ya :)

@SachinSamy 10 лет назад

Hey Mag, Thanks for watching the video did you seen the full video. The script automatically deletes the old backup once it reaches the defined date. please let me know if you have any problem See Ya :)

@SachinSamy 10 лет назад

Hey Moe, Yes this works on Windows Xp and SQL express 2008 if you have any problem if you have any problem See Ya :)

@j.q.6208 5 лет назад

it worked for my SERVER that is not part of the Domain, but did not work for MY SERVER that is part of the domain, task scheduler does not giving error, but not backing up, any help is appreciated. please.

@rizkimaulana3111 5 лет назад

Hi Sachin Sammy,

@jimmyboyn 8 лет назад

well done video. Wish it was better quality HD video to see better but I think you covered it all.

@murugeshl1505 Год назад

hai sachin i followed your video, the script run successfully but backup folder is empty pls help me

@md.abulkalammusa3962 3 года назад

what if I login to sql server using sql login credential & not using windows login ? is there any issue with that? tnx for this tutorial.

@sandrodwicahyo3479 11 лет назад

COOL ... awesome it work !! Thank u very much !! before I saw this video I always failed to make a batch file....thanks again buddy

@9909striker 6 лет назад

Hi sachin I am having some issues with creating the backup, can you please help me out

@JanardhanReddyTanubuddi 6 лет назад

Then how to get the email alerts for backup failure or success

@TummalaAnvesh 9 лет назад

Hi Sachin, It is a clear demo. Also I am glad, that scripts works for me. I even tried to take the differential backup instead of daily taking the complete backup with a small change of 'D' instead of 'F' in the 12 Am batch file. But I am getting a new backup file with less size. What I am looking for is a way to merge the differences with existing backup. Is it possible with any script tweaks.