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


i have database (ms 2005 server). how bak or mdf file but; running windows 2008 server on 600 stuffs using db. if .bak file or mdf. must close connection. dislike it. there useful methods or method bak or mdf? method may exe or ms sql property or tool?

you not need drop users make backup. right click database in sql server management studio -> tasks -> up

even better, setup regular backup schedule.

here's further instructions on backing sql server 2005.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -