Backup of Read Only Database.

Hi,
Is it possible to take backup of read only database?
If yes then
How? and
If No? then
There is any Microsoft official link which can clarify the answer.
please give reply as soon as possible.
Kind Regards,
Sajid.Hi,
Yes you can backup a read only database (confirmed it for myself on SQL
Server 2000 and 2005).
You can do it using Enterprise Manager (SQL Server 2000) or Management
Studio (SQL Server 2005). Alternatively, you can use T-SQL to do it
through the use of the BACKUP DATABASE statement.
SQL Server Books Online is a good resource to look up how to do it if
you need a refresher.
Hope that helps a bit|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
Thanks for this reply.
Can you pls. giveme the exact BACKUP DATABASE Statement.
Thanks and Regards,
Sajid.|||Hi,
If you want to back up your database to a file, then your statement
should look like:
BACKUP DATABASE <Insert Database Name>
TO DISK = 'C:\Example_Backup.bak'
Hope that helps a bit|||Hi,
Thanks for your quick reply.
Again i want to know that can i take a backup of database which is in
standby mode.
if the ans. is yes then pls. tell me how can i do it?
Thanks and Regards,
Sajid.
nate.vu@.gmail.com wrote:
> Hi,
> If you want to back up your database to a file, then your statement
> should look like:
> BACKUP DATABASE <Insert Database Name>
> TO DISK = 'C:\Example_Backup.bak'
> Hope that helps a bit|||Read only is not the same as standby mode. Unfortunately, I believe that the
tools that comes with
SQL Server blurs this. No, you cannot take a backup of a database in standby
mode (restored using
the STANDBY option).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<csajid@.gmail.com> wrote in message news:1147689430.310228.284590@.v46g2000cwv.googlegroups.c
om...
> Hi,
> Thanks for your quick reply.
> Again i want to know that can i take a backup of database which is in
> standby mode.
> if the ans. is yes then pls. tell me how can i do it?
> Thanks and Regards,
> Sajid.
>
> nate.vu@.gmail.com wrote:
>

Backup Jobs Locking ?

When you run a Backup Job (Database or TRN), is the database locked during the database?

If yes, to what extent?

Thanks

There are no locks that are not compatible with any user locks, but only those which could prevent database from deletion, for example.