开发者

How to get Bak file or MDF without close connection sql server?

开发者 https://www.devze.com 2023-02-09 16:47 出处:网络
i have a database (ms 2005 server). How to get bak or mdf file BUT; it is running windows 2008 server also over 600 stuffs is using this DB. if i get .bak file or mdf. i must close connection. i disli

i have a database (ms 2005 server). How to get bak or mdf file BUT; it is running windows 2008 server also over 600 stuffs is using this DB. if i get .bak file or mdf. i must close connection. i dislike it. is there any useful methods or method to get BAK or MDF? this method ma开发者_运维百科y be a EXE or ms sql property or tool?


You certainly do not need to drop users to make a backup. Just right click your database in SQL Server Management Studio -> Tasks -> Back Up

Even better, setup a regular backup schedule.

Here's further instructions on backing up SQL Server 2005.

0

精彩评论

暂无评论...
验证码 换一张
取 消