Database Backup

Is there a way to backup a database to CD?
1 - On a CD burner that is NOT attached to the server
2 - On a CD burner that IS attached to the server
Thanks,
-mac-
If the obvious weren't so obscure, I'd be less confused.
I have a SQL Server DB that backs up directly to drive F, which is the
burner in the local machine. Works like a champ.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Mac Davis" <news@.blindsided.org> wrote in message
news:e7himmuOEHA.1340@.TK2MSFTNGP12.phx.gbl...
> Is there a way to backup a database to CD?
> 1 - On a CD burner that is NOT attached to the server
> 2 - On a CD burner that IS attached to the server
> Thanks,
> -mac-
> If the obvious weren't so obscure, I'd be less confused.
>
|||And if you want to backup to another machine, you have to
map a network drive to the distant burner
then set DBCC TRACEON(1807) option (this allows backups
on network drives)
i did not actually tried it, but i think this should help
Regards
JL Gervais

>--Original Message--
>I have a SQL Server DB that backs up directly to drive F,
which is the
>burner in the local machine. Works like a champ.
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Mac Davis" <news@.blindsided.org> wrote in message
>news:e7himmuOEHA.1340@.TK2MSFTNGP12.phx.gbl...
>
>.
>

Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieBHi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is =
> Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieB
Hi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is =
> Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database Auto Shrink

I have unattached and taken some databases from an Enterprise version of SQL
and attached them onto a Personal Edition laptop. Although I have deselected
the auto shrink option, on a daily basis it reappears, shrinks my files and
my data import crashes.
So my quesiton is =
Is there a way to disable autoshrink on the Personal edition or do I need to
rebuild the laptops on NT Server.
Many Thanks,
RichieBHi
Right click on the database and click on Properties. Under Tbal Options
uncheck AutoShrink option.
"RichieB" <RichieB@.discussions.microsoft.com> wrote in message
news:F3BFBD6F-910A-4A91-BC0C-80E34B1B1A3A@.microsoft.com...
>I have unattached and taken some databases from an Enterprise version of
>SQL
> and attached them onto a Personal Edition laptop. Although I have
> deselected
> the auto shrink option, on a daily basis it reappears, shrinks my files
> and
> my data import crashes.
> So my quesiton is => Is there a way to disable autoshrink on the Personal edition or do I need
> to
> rebuild the laptops on NT Server.
> Many Thanks,
> RichieB

Database attach at setup

Hello,

Our product has a MDF file included with the setup, this needs to be attached at the current SQL Server (Express or not).
Where can we copy the MDF file during setup so it can be attached successfully ? We need a place where the account SQL Server is running under has write permissions.

Please help !
Thanks

You can always use CREATE DATABASE mydb ON ( FILENAME = 'mydb.mdf')
to attach a database after installing sql server.

refer to http://msdn2.microsoft.com/en-us/library/aa258257(SQL.80).aspx for more details.

or you can do attach database via management studio

Look into this link: http://msdn2.microsoft.com/en-us/library/ms190209.aspx

|||

Embedded database feature is only available in SQL Server Express. In express, in connection string you can mention UserInstance and attach mdf file. But in all other versions, you will have to attach the database using some sqlscript explicitly. And also connection string will differ in both method

Refer this link for userinstance :

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

Madhu

database (read-only)

I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?

database (read-only)

I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?
ALTER DATABASE pubs SET READ_WRITE
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?
|||ALTER DATABASE dbname SET READ_WRITE
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?

database (read-only)

I attached a database with sp_attach_db but it ended being read-only. Is
there a script that can change my database from being read-only?ALTER DATABASE pubs SET READ_WRITE
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?|||ALTER DATABASE dbname SET READ_WRITE
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"Arne" <Arne@.discussions.microsoft.com> wrote in message
news:7841BD45-E305-49A7-8037-C821B891C799@.microsoft.com...
>I attached a database with sp_attach_db but it ended being read-only. Is
> there a script that can change my database from being read-only?