tag:blogger.com,1999:blog-9075786158122089104.post1530450612132494743..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Copy LDF and MDF file without stopping SQL Server services:Ritesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9075786158122089104.post-68780418310023830472011-11-12T20:38:23.209+05:302011-11-12T20:38:23.209+05:30Hello Vugar,
Thanks for your comment.
Since data...Hello Vugar,<br /><br />Thanks for your comment.<br /><br />Since database is offline, user will face downtime until you execute command to make database online.<br /><br />if you don't want to face offline than take backup of your database and if needed restore it somewhere else. this would be efficient for your need I guess.<br /><br />RiteshRitesh Shahhttps://www.blogger.com/profile/09562656548324468450noreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-21196114066778850442011-11-12T17:02:25.817+05:302011-11-12T17:02:25.817+05:30This Very good sample. Thank you !
Bu i want to ...This Very good sample. Thank you ! <br /><br />Bu i want to ask this - If my Data file ( mdf and ldf) are greater than 300-400 MB this process will take some minutes. May be other user work with this sql server form other computer in the same time?? Will there any problem? <br /><br />Thanks, <br />Vugar Avazov, avazov@yahoo.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9075786158122089104.post-2455043415292236142009-06-30T10:46:35.240+05:302009-06-30T10:46:35.240+05:30Ritesh, This is great stuff. I never knew that thi...Ritesh, This is great stuff. I never knew that this is possible while the database server is online.Bihaghttps://www.blogger.com/profile/16503827593636769915noreply@blogger.com