Connect to databsase in nonstandard location
- From: "mr_doles" <toddlisa2@xxxxxxxxxxx>
- Date: 8 Jul 2006 09:51:22 -0700
I am writing a Database application using Visual Studio 2005 and SQL
Server Express 2005. I am trying to create a back up and year end back
up plan within the program. The folder structure I want is as follows:
The main level is c:\program files\app name\database with the following
subfolders, 1) current - holds the current db (db.mdf), 2) backup -
holds the backed up databases (db1.bak) and 3) archive - holds the
year end databases (db-2005.mdf). I have two questions:
1) How do I setup the connection string to connect to a database that
is not located in the standard C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data location?
2) Is there a way to setup the security on the backup folder during
setup to allow the SQLServer2005MSSQLUser write access? I was getting
access denied running the BACKUP DATABASE db TO DISK sql statement.
.
- Prev by Date: Re: New Server Cannot 'See Out'
- Next by Date: Re: SQL 2000, Named Pipes and Windows 2003 Standard
- Previous by thread: New Server Cannot 'See Out'
- Next by thread: Re: Problem connecting AS400/DB2 with SSIS
- Index(es):
Relevant Pages
|
Loading
