Backup Through Job

Question

Backup Through Job

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

ps. (11/10/2010)
actually 9 jobs were not required. 1 job could have backed up all nine databases one by one.

This is true, but it gives more flexibilty if you create a different job for each database. It means you can schedule them individually and take ad hoc backups of single database. It's very tedious to create the separate plans, but you only have to do it once and we find it's worth the effort.

John

mca.vimal Ten Centuries Points: 1050 More actions · Answer 2

actully i am the only one here in the company which is play with database .

i have installed SQL Server On Server with limited selection ,when i go through maintaince plan i have no plans see or i am unable to take backup through maintaince plans becoz it not showing the .........

then i got htrough SQL Agent Job ..

where i create nine jobs for all ...

thell me how to take bachup of all DB in one job......

Vimal Kumar
9999797952

ps. One Orange Chip Points: 29422 More actions · Answer 3

may be and may be not. I have some instances hosting more than 100 databases and it will really not be feasible to create so many backup jobs. Also, if you have separate backup jobs for each database, you need to ensure they run at different times or else you may see IO contention.

For ad-hoc backups it's also easy to do it using SSMS or by running a simple backup command.

Pradeep Singh

mca.vimal Ten Centuries Points: 1050 More actions · Answer 4

what is the SSMS i don't have any ideia abt that

Vimal Kumar
9999797952

ps. One Orange Chip Points: 29422 More actions · Answer 5

mcavimal-736871 (11/10/2010)
what is the SSMS i don't have any ideia abt that

SQL Server Management Studio.

Pradeep Singh

mca.vimal Ten Centuries Points: 1050 More actions · Answer 6

Ohhhh !!!!!!!!

thanks

could you please tell me hoe to check the rights of SQL Agent on The backup folder.

coz i have admin rights . so i think i don't have any prob to do it.

Vimal Kumar
9999797952

mca.vimal Ten Centuries Points: 1050 More actions · Answer 7

one more thing please tell me i can take LOG Files BAckup Without Stop the services of SQL 2005 Server.

i All ready stop the agent and i don't got any success

Vimal Kumar
9999797952

ps. One Orange Chip Points: 29422 More actions · Answer 8

mcavimal-736871 (11/10/2010)
one more thing please tell me i can take LOG Files BAckup Without Stop the services of SQL 2005 Server.
i All ready stop the agent and i don't got any success

You do not need to stop sql agent/sql server for log backup.

pls see this http://msdn.microsoft.com/en-us/library/ms179478.aspx

Pradeep Singh