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

752 Views Asked by At

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 may be a EXE or ms sql property or tool?

1

There are 1 best solutions below

0
On BEST ANSWER

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.