backup restored to an MSDE

Does Microsoft officially support restoring a standard edition DB to the MSDE?
Thanks, and a link would be great....
burt_king@.yahoo.com
Sure, this works.
|||I know it works; is it officially supported?
burt_king@.yahoo.com
"Jens" wrote:

> Sure, this works.
>
|||Sure, thats a normal upgrade / upscaling path.
HTH, jens Suessmeyer.
|||I can't find any Microsoft resource --Books on line or other-- that agrees
with your statement that it's supported. Can you point me to a resource?
burt_king@.yahoo.com
"Jens" wrote:

> Sure, thats a normal upgrade / upscaling path.
> HTH, jens Suessmeyer.
>

backup restored to an MSDE

Does Microsoft officially support restoring a standard edition DB to the MSD
E?
Thanks, and a link would be great....
burt_king@.yahoo.comSure, this works.|||I know it works; is it officially supported?
--
burt_king@.yahoo.com
"Jens" wrote:

> Sure, this works.
>|||Sure, thats a normal upgrade / upscaling path.
HTH, jens Suessmeyer.|||I can't find any Microsoft resource --Books on line or other-- that agrees
with your statement that it's supported. Can you point me to a resource?
burt_king@.yahoo.com
"Jens" wrote:

> Sure, thats a normal upgrade / upscaling path.
> HTH, jens Suessmeyer.
>sql

backup restored to an MSDE

Does Microsoft officially support restoring a standard edition DB to the MSDE?
Thanks, and a link would be great....
--
burt_king@.yahoo.comSure, this works.|||I know it works; is it officially supported?
--
burt_king@.yahoo.com
"Jens" wrote:
> Sure, this works.
>|||Sure, thats a normal upgrade / upscaling path.
HTH, jens Suessmeyer.|||I can't find any Microsoft resource --Books on line or other-- that agrees
with your statement that it's supported. Can you point me to a resource?
burt_king@.yahoo.com
"Jens" wrote:
> Sure, thats a normal upgrade / upscaling path.
> HTH, jens Suessmeyer.
>

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.com...
> 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
>

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:
>