October 19, 2003 at 7:42 am
how to create on-line backup in sql server, while running online server
balaji ramanar
balaji ramanar
October 20, 2003 at 8:58 am
SQL Server does not require you to take the server offline for backup. You can back it up anytime. However it will slow down user process if there are too many users connected.
mom
October 20, 2003 at 9:05 am
Use a Database maintenance plan to schedule a backup /
Alternatively
Right click on database in question select all tasks
and select backup database (at an appropriate time)
As said earlier in your post there is a price to pay in terms of performance
Mike Ngong
October 21, 2003 at 3:19 am
Use a maintenance plan (maybe with assistance from the wizard).
You might notice a slight performance overhead, but depending on your hardware you shouldn't be affected too much.
However, although you can do online backup you might want to consider scheduling this for timeperiods with less activity.
Are you trying to do a local backup?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply