how can I connect to .MDF through 2 applications?

Here is the big problem:

I am using ASP.NET 2.0 login control. this control connect to ASPNET.MDF database.I built another application using windows service, and this application also connects to ASPNET.MDF database.

problem is that the first application that connects to the database, locks the database, and so the other application cannot use the database untill the other application is closed.

I am going on circles about this, and just don't know what to do.

Please please please. love me do.

I don't think you can use the membership database for none Asp.net application because a console application is not Asp.net application, but if you could maybe you should create one for each application as the link below from a Microsoft security forum. The reason is by default every application uses the same application name to access the database so why not create one for each application so it is clean. Post again if you still have question. Hope this helps.

http://aspalliance.com/groups/microsoft_public_dotnet_framework_aspnet_security/ng-645637_Membership_Database_Security.aspx

sql

How can I attach the ASPNETDB mdf to SQL 2005?

I want to import a table and data in SQL 2005 to the table in the ASPNETDB mdf. Please help.

Do you know where the database is?

I would recommend you to read this series to get start. You will be there.

http://aspnet.4guysfromrolla.com/articles/040506-1.aspx

|||Dumb Questions...what do I type in to get here...navigate to%WINDOWS%\Microsoft.NET\Framework\v2.0.50727|||I figured that out. How do I runaspnet_regsql.exe|||double click on it.sql

How can I attach AdventureWorks Database to SQL Server Management Studio Express?

Hi all,

I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:\Program Files\Microsoft SQL Server\MSSQL.1|\MSSQL\Data folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise.

Thanks,

Scott Chang

P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.

Hi Scott,

You can't type in the name of the database, you need to click the Add button, which will open a browse window onto the Data folder, where you can select the MDF file you desire. Once added, you can click OK to complete the attach.

Mike

|||

Why are some folders unbrowsable in SSMSE? I have an .mdf file located under c:\documents and settings\myusername\blah blah blah.... and when I try to browse to my mdf file I get no further than c:\mydocuments\myusername. As if there are no subfolders. Is this a folder rights issue?

|||

Yes, it's a folder rights issue.

SQL Express runs as the Network Service account, which doesn't have permissions to any of the User profile directories such as My Documents. If you want to have your database always attached to SQL Express and available to everyone, then you should put the file in the SQL Data directory and attach it from there. If you want the database to be reserved for just a single user, then I would suggest you explore User Instances, which is a special way to run SQL Express under specific users accounts so that it does have permission to the User profile directories.

User Instances are used by default when you insert a database into a Visual Studio project. You can find more information here.

Mike

How can I attach AdventureWorks Database to SQL Server Management Studio Express?

Hi all,

I just downloaded AdventureWorks_Data.mdf, AdventureWorks_Data.ldf, AdventureWorksDW_Data.mdf, and AdventureWorksDW_Data.LDF files to the C:\Program Files\Microsoft SQL Server\MSSQL.1|\MSSQL\Data folder of my Windows XP Pro PC. I tried to attach the AdventureWorks database in my SQL Server Management Studio Express in the following way: I clicked on SQL Server 2005 Express=>SQL Server Management Studio Express=>Right clicked on Databases=> clicked on "Attach..."=> "Attach Databese" showed up. But I can not type in anything under the MDF File Location, Database Name, Attach As, Owner, Status, Message!!!? What is wrong in my way of doing the attachment of AdventureWorks database (described above)? Please help and advise.

Thanks,

Scott Chang

P. S. I do not have Microsoft Visual Studio 2005. Walkthrough: Install the AdventureWorks Database (http://msdn2.microsoft/en-us/library/ms31035.aspx) : To confirm your SQL Server data directory (Start=>All Programs, Microsoft Visual Studio 2005, Visual Studio Tools, Visual Studio 2005 Command Prompt) steps 1 thru 4 can not be applied to my SQL Server Management Studio Express. I read an SQL Express post dated 19 April 2006 and learned the above-mentioned way to attach the AdventureWorks database in the SQL Server Management Studio Express. But that way does not work for me.

Hi Scott,

You can't type in the name of the database, you need to click the Add button, which will open a browse window onto the Data folder, where you can select the MDF file you desire. Once added, you can click OK to complete the attach.

Mike

|||

Why are some folders unbrowsable in SSMSE? I have an .mdf file located under c:\documents and settings\myusername\blah blah blah.... and when I try to browse to my mdf file I get no further than c:\mydocuments\myusername. As if there are no subfolders. Is this a folder rights issue?

|||

Yes, it's a folder rights issue.

SQL Express runs as the Network Service account, which doesn't have permissions to any of the User profile directories such as My Documents. If you want to have your database always attached to SQL Express and available to everyone, then you should put the file in the SQL Data directory and attach it from there. If you want the database to be reserved for just a single user, then I would suggest you explore User Instances, which is a special way to run SQL Express under specific users accounts so that it does have permission to the User profile directories.

User Instances are used by default when you insert a database into a Visual Studio project. You can find more information here.

Mike

how can attack database from sqlserver management studio express?

I have created a database named s_office,now i want add file data.MDF and log.LDF into it. .How can i do it?Could you show me the script that attack file .MDF and .LDF into database.thankxhttp://msdn2.microsoft.com/en-us/library/ms179877.aspx

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit?
Thanks
AlSomething like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
--
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit?
Thanks
Al
Something like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al
|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database
is 4 GB so far (MDF file) every month is growing around 100 MB, what's the
limit?
Thanks
AlSomething like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al

How and where should I create a mdf file if I installed a sql server 2005(Developer EditioN)

hi:

I am a newbie to sql server 2005 (developer edition). Now I installed both sql server and VS 2005 professional edition on my machine.

I just what to know how and where should I create a mdf file on my server or .net window project because I try to combine to it from a window application. Should I use the sql server management studio or the Visual Studio 2005 ? What is the generate steps to create one?

I am completely confused. Please help me, I cannot find related on line source.

Thank you, thank you

bigheadjj

That depends wheter you want to use a user instance with a SQL Server database or a SQL Server hosted instance. The Visual Studio Database can support both, whether a user or a server instance. Did you have the concept of a user instance or a server instance ? If not, I would suggest you reading the principles of that in the web.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Even if VS 2005 can connect to the server and create database files, I recommend that you use the SQL Server client tools (SSMS, sqlcmd, etc.) This gives you a good understanding of what is happening on the database side. Plus, using the SQL Server client tools, you can configure other database options which cannot be done using VS 2005|||

Jens

Thank you very much. I will start to read related principles as you suggested.

|||

bass_player

thank you for helping me. Your recommendation is very helpful.

Hot Backup

Someone told me should backup the live data files (files with
extension MDF and LDF) instead of the backup files (file with
extension BAK) in hot backup. I don't think it work in the case I need
to restore these data files from tape backup. Am I correct?That person might be thinking about the various type of snapshot backup products that exists. This
type of backup uses some technique to "freeze" the I/O for some period of time and then use some
journaling to keep track of the modifications performed while the backup is running (while you are
copying the files). There's some information in SQL Server 2005 Books Online, search for instance
for "VSS Writer" (which is the service in SQL server to assist these types of backup programs).
But in general you are right. You don't want to just "grab the database files".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<viet@.rocketmail.com> wrote in message
news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
> Someone told me should backup the live data files (files with
> extension MDF and LDF) instead of the backup files (file with
> extension BAK) in hot backup. I don't think it work in the case I need
> to restore these data files from tape backup. Am I correct?|||On Apr 24, 6:47=A0pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> That person might be thinking about the various type of snapshot backup pr=oducts that exists. This
> type of backup uses some technique to "freeze" the I/O for some period of =time and then use some
> journaling to keep track of the modifications performed while the backup i=s running (while you are
> copying the files). There's some information in SQL Server 2005 Books Onli=ne, search for instance
> for "VSS Writer" (which is the service in SQL server to assist these types= of backup programs).
> But in general you are right. You don't want to just "grab the database fi=les".
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph=
ttp://sqlblog.com/blogs/tibor_karaszi
> <v...@.rocketmail.com> wrote in message
> news:2341c184-ec8b-42d7-b250-3e5acd594e49@.w8g2000prd.googlegroups.com...
>
> > Someone told me should backup the live data files (files with
> > extension MDF and LDF) instead of the backup files (file with
> > extension BAK) in hot backup. I don't think it work in the case I need
> > to restore these data files from tape backup. Am I correct... Hide quoted= text -
> - Show quoted text -
If the intention is to backup the database before tape backup . You
can always schedule the db backups online before tape backup and
the .bak files can be backed up on tape.
If the database size is very large you can use the tools like
Litespeed which will help you to save on time.
Thanks
Ajay Rengunthwar
MCTS,MCDBA,MCAD

Hosting Provider SQLExpress

Hi to All,

If I create a Web Application using VWD and use an MDF file on APP_DATA, I need that my Hosting Provider have SQL Express on server where resides IIS?

Thank You!

If you are looking for free hosting provider then read this

http://forums.asp.net/1145182/ShowPost.aspx

Regards