New Database On Other Local Network Drive

Jan 15, 2007

Hello,

I need help with the setup of my sql server express 2005 and more specifically, with the location of the database files.  Normally, database files are located on the c: drive.  In my situation, being in a high school environnement, I need to have the database files on the network drive ... lets call it g:drive.  The reason why it cannot be on c:drive is because this drive is protected using DeepFreeze.  Now, I was able to change the location of the new drive as I went into the properties window of the sql server instance but when I try to create this new database, sql gives me grief  ;-|

 I am from the group of people that thinks that to anything, there is a solution and am hoping that to this problem, there is hope of a solution.

 Can anyone help?

 Thank you 

View 1 Replies


ADVERTISEMENT

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

Backup On Local/Network Drive Using Maintenance Plan

May 27, 2007

Hi,
I have created an sql server 2005 maintenance plan for a daily backup. The plan has two 'Back up database task' i.e. one backup on the local drive while the second on a network drive. When the plan is executed, a backup is created on the local drive but not on the network drive. If i check the log, it says "Access Denied" whereas i have full access to the network drive with complete permissions to read, write and delete.
Can anyone help me understand how to take a backup on both a local and network drive at the same time using a maintenance plan ? I shall be obliged...
Regards...

View 2 Replies View Related

I Have A Database On A Network Drive That I Use For Archiving Purposes, But When The Server Is Rebooted The Database Becomes Suspect.

Mar 31, 2007

I created the db with the attached script and I am able to access ituntil I reboot the server. I've tried enabling flag 1807 via the SQLserver service and the startup parameters of the instance. In allcases the database always come up suspect after a reboot. There wasone instance where I was able to recover, but I am not sure how thathappened.Does anyone have an idea of how I can reboot the server without thedatabase becomming suspect?USE MASTERGODBCC TRACEON(1807)GO--DBCC TRACEOFF(1807)--DBCC TRACESTATUS(1807)GOCREATE DATABASE ReadyNAS ON( NAME = ReadyNAS_Data,FILENAME = '\NAS1NASDiskSQL ServerReadyNASReadyNAS_Data.mdf',SIZE = 100MB,MAXSIZE = 20GB,FILEGROWTH = 20MB)LOG ON ( NAME = ReadyNAS_Log,FILENAME = '\NAS1NASDiskSQL ServerReadyNASReadyNAS_Log.ldf',SIZE = 20MB,MAXSIZE = 100MB,FILEGROWTH = 10MB)

View 5 Replies View Related

Create Database On Map Network Logical Drive

Oct 13, 2000

In 6.5 , I was NOT able to use mapped network drive for new database
device if the MSSQLSERVER service is running under local system account,
but if I changed it to using a domain a/c which has the authority to
create files on mapped drive, I was able to do it.

But if I tried it in 7.0, it never work and got msg:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'e:est2.mdf' may be
incorrect.
Server: Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check
previous errors.


Is it something that's normal for 6.5 and 7.0 ????
i.e. we can only create databases on LOCAL drives ?
I am just thinking of in case we run of space locally, we can temporarily
make use of remote mapped network drive. (say at time of upgrading)

Any one has this experience ?

View 2 Replies View Related

Unable To Create A Database On A Network Drive

Dec 8, 2007

I have a network drive that is mapped as Z: on my local machine. When creating a new database, that drive does not show up in the list of available paths. If I try to hardcode the drive/path info, I get an error message: "The system cannot find the path specified."

View 1 Replies View Related

Unable To Connect To My SQL Database File Via A Network Drive

Apr 29, 2008

I recently created a program that connects to a Microsoft SQL database that was stored on my computer and it worked fine. As soon as I tried to connect to the same database via a network drive I got an error stating that "The file Y:Filename.mdf is on a network path that is not supported for database files.". I can't seem to get it to work, if anybody has any ideas what I'm doing wrong I would appreciate your help.

Don

View 5 Replies View Related

Error 18210 Backup Up SQL Server 2005 Database To Network Drive

Aug 1, 2007

I have 2 different servers that run nightly backup jobs to a network drive using the UNC format. I am noticing the larger databases encountering the following errors on a regular basis

Error: 18210, Severity: 16, State: 1.
'\fnfssql3SQLBackupsMNSQL05<database>.BAK'. Operating system error 64(The specified network name is no longer available.).
BACKUP failed to complete the command BACKUP DATABASE <database>. Check the backup application log for detailed messages.



There are 5 databases on this server all backed up by the same job and 3 of them wortk fine and 2 of them fail so it is not a permissions problem. Have there been any problems with backing up to a network drive in 2005?

View 4 Replies View Related

Database Security On A Local Network

Jan 14, 2007

This is regarding general protection of a database hosted on a network. I am developing a database application for my college library using VB.NET, that will reside on a network.
For some reasons, I did not want to hardcode the Database location in the application. Instead, when a user logs in, he can choose the database location using a folder browser control, if the location has changed.

Now, I realize that for this, I have to put the database in a shared folder, which makes it quite vulnerable. Having pondered over the problem for sometime, a solution that comes to my mind is to place a Text file in the same shared folder that always contains the correct path of the database. When a user chooses that folder, I will read the actual path of the database from the text file, and move the database to a non-shared folder.
I haven't yet implemented this approach, but felt it better to consult someone before. So, would this approach work, and is it a good idea.
For information purposes, I consider it important to mention that the database is in MS Access. I know this is not a place for discussing it, but this is a general security concern. So, I thought
people would not mind answering it....

View 7 Replies View Related

How To Sync Local Database With Network Database

Dec 23, 2006

Hi

Scenario: In general user will take database backup from database server to local system. User perform some changes to his local database based on his requirement. Again user connects to database server and click on update, local database should update to server database by informing each record status to the user. ex: record 1 updated / call closed do you want to update?

Here local database is going to be Pocket pc database and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply.

Thanks,

View 2 Replies View Related

SAN Drive Speed Vs Local Drive

Feb 12, 2007

How do you compare SAN drive vs local drive on a 32 bit server?

Is it good idea to move my DB files to a SAN instead of local?

Canada DBA

View 4 Replies View Related

Database Connection: Mapped Network Drive (VC++ Express, MSSQL SMS Express, XP)

Sep 8, 2007


Hi


I have VC++ express and MSSQL SMS express and have an application working nicely locally. The Data explorer and data connections part works really easily.

Now, I want to make the application available to my home network.

I mapped the drive where the database is and called it Z: so I could put my "release" on my other network PC and assumed it would find Z: if I mapped the shared network drive on that machine and called it Z:

But: I can't even add the mapped connection on the local machine, I get:

The file "Z:databasescalorie.mdf" is on a network path not supported for database files. An attempt to attach.....etc"

It works fine on the original F drive.......

Am I approaching this the wrong way. How should I distribute to network PCs?

thanks hopefully
David

View 5 Replies View Related

Moving A SQL Server 2005 Database From The Local Network To An Online Server.

Mar 7, 2006

Hi All, first post.

I have done a bit of searching around and cant find a clear answer to this question.

Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)

It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.

The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.

This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.

Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.

So the only thing that would change would be a new connection string in the application preferences?

Or am I living in a dream world, because nothing is ever that simple.

One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.

Thanks for any advise you can give.

Mark

View 2 Replies View Related

Remote Network Drive

Apr 24, 2008

I have an SSIS package which accesses a map UNC path drive. It works fine when I run SSIS from Visual Studio. However, when I run this from a SQL Server job, it gives an error.

I am not allowed to use xp_cmdshell due to security reasons. If someone can point me to right direction, that would be greatly appricated.

Thanks

Z

View 20 Replies View Related

Restoration From Network Drive

Jul 23, 2005

Hi,When i use to work on Windows 2000 advance server and Sql 2000I was able to do network restoration by using a mapped drive where mybackup use to be lying.What i did was I assigned administrator rightsto my login and in Services (mssqlserver)i added my login.Then I was able to access any mapped drive from my network in Sqlserver 2000.Now i have switched my OS to Windows Server 2003.What I want to know is , is their any other setting that has to donefor network restoration , because after following above steps then to Iam not able to access mapped drive in SQL SERVER 2000.So can anyone help me to know what setting should i do in Windows 2003server or in SQL Server 2000 to do a network restoration of database.Thanks in advanceTV

View 1 Replies View Related

Ftp Task To Network Drive?

Sep 12, 2007

Hi I have a simple ftp task that downloads some files from an ftp to a local directory. That package run as a sheduled job from the sql 2005 server without a problem so far.

Now I whant to have the same task but to download the files to different mapped network drives , so I mapped the drives then I changed the paths to the config file but since then the job fails...

is it possible to do that or I did something wrong?

Thanks
g

View 4 Replies View Related

Backup Db To Network Drive Problem

Nov 20, 2001

We're trying to backup some dbs to a network drive but fail.

I read that the 'a/c to run SQLAgent must be a domain user a/c with
proper permission to access the network drive.'

What is proper permission? Read, Write ?

Only the a/c that runs SQLAgent needs the proper permission, the job's owner doesn't?!?

Thanks in advance,
Ben

View 1 Replies View Related

Maaping A Network Drive From Within A DTS Package

Nov 25, 2001

I am using SQL2K server. I have a scheduled job which invokes a DTS package. One of the tasks in the DTS package invokes an OS command (from a .bat file) to map a network drive to b made available (dynamically, referring to a mapped drive letter, say "Y" or "Z") in successive tasks to refer to a source or destination TEXT file(s). Basically, the DTS package must be able to refer to the TEXT files (source/destination, depending on the task I have) located somewhere in the network. [ I use the NET USE command in the .bat file to map the network drive.)

The DTS package works stand-alone from SQL Enterprise Manager.
But, when the package is invoked from a scheduled job, the step containing the DTS package fails - the task which maps the network drive fails - access violation /session error...
How do I handle the batch job to overcome this problem?
I appreciate tips/solutions from anyone....
Thanks.
K.K.Rengan

View 1 Replies View Related

BACKUP To Maped Network Drive

May 4, 2000

Hi guys.

Has anyone ever done SQL DB backup directly onto a maped network drive?

We've got a really huge DB 100GB+ that just wont fit into the local Hard Disk for backup.

Thank you in advance for your help.

Cheers,
Stephen

View 3 Replies View Related

Backup Fails On Network Drive???

Nov 14, 2000

I have creted a backup device on network drive and getting the following error when I run the backup command as a job.SQL server and the agent are running on a domain account which has full permission on the network drive.Any help is greatly appreciated.
Thanks!


"Cannot open backup device 'mccdiffbkpond2build'.
Device error or device off-line. See the SQL Server error
log for more details. [SQLSTATE 42000] (Error 3201) Backup or
restore operation terminating abnormally. [SQLSTATE 42000]
(Error 3013). The step failed"

View 1 Replies View Related

Network Drive Not Available In Backup Schedule

Oct 24, 2000

I am setting up a backup on one of my DB's and the network drive does not appear as an location that I can backup too. Only the C drive is present. However, on the server I do have a drive mapped to the network drive, so it should be available. Has anyone encountered this issue before?

Thanks!

Scott

View 10 Replies View Related

Backing Up To Network Drive Without Trust

Oct 23, 1998

I need to know if there is a way to perform a SQL Server 6.5 backup to a remote network drive WITHOUT USING A TRUST LOGIN.

My network administrator refuses to put a TRUST relation on the Primary Domain Controller. I`m not really sure why, but I need a workaround.

Thanks,

"Work-around Bob"

View 1 Replies View Related

[MSSQL7] Backup On Network Drive

Feb 2, 2004

Hi there,

Does anyone know if it's possible to perform a MSSQL7 database backup on a network drive instead of the local drives ?

...and if yes, how to proceed ?

It seems to be possible under MSSQL2000.

Many thanks for your help in advance,

Matt

View 6 Replies View Related

Sdf File On Shared Network Drive ?

Nov 29, 2007

I know , it is not going to work , just wondering if anyone could give any reasons for that. Whether it was intentional constraint or just internally compact edition was designed in particular way which makes such a usage not possible. It is a pity that it doesn't work that way as it would be much easier transitional path for many Visual Foxpro , MS Access applications.
In my case I just want READ-ONLY database either for multi-user access via shared drive or stand-alone on local drive.

View 1 Replies View Related

Cann't Able To Take Backup On Network Drive...........

Mar 17, 2008



HI
i am trying to take a backup on Network drive but i am getting following error message. althought when i try to type the address in window explorer. i can access the specific folder. so that there shouldn't be network security issue.... and even thought the backup device name is correct.
when i try to take backup on local disk, it work's fine....


Executed as user: NT AUTHORITYSYSTEM. Cannot open backup device 'FullBackup(\0.0.0.0SQL_BackupsFullBackupsFullBackup.bak)'. Operating system error 5(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

View 6 Replies View Related

Access Denied For Network Drive

Oct 4, 2006



Sql server prompts "access denied"

while firing the following query

EXEC master..xp_cmdshell 'dir \servernamesharedfolder*.* '

how to access the folders and files existing in network drive.

View 3 Replies View Related

Backing Up Data To Network Drive Mapped

Aug 6, 2003

I am new to the DB Administration.

How do i back up the data to a network drive mapped on a day to day basis.

View 4 Replies View Related

Creating A Semaphore File On A Network Drive

Jul 11, 2007

Good Morning,



I'm hoping that someone can help me. I have a SQL 2005 SSIS package that will run Friday mornings to empty/load a table with data from another database. On Friday evenings I'll need to run another package, but want to make sure the table load completed prior to launch. For this I planned to use a file watcher task, however I cannot for the life of me figure out how to output a 'done' semaphore, from the morning job, to a networked drive.



A file system task will not work because there is not a 'create file' option. I do not have an existing file that I can rename either.



I tried an execute process task running cmd.exe with the following argument:


Code Snippetecho Done> \NetworkedServerftprootLoad.Done

This fails because UNC paths are not recognized. (The package executes from another server so I cannot use a local path, nor am I allowed to set-up a local share.)



Can someone offer an alternative suggestion? I'm really hoping this is easier than I'm making it.



Thank you in advance,

Roger



View 3 Replies View Related

Reading/writing Files To Network Drive

Mar 20, 2007

We have a package that is using a ForEach loop container to access files on a network drive. For some reason I am getting a message that the ForEach enumerator is empty and did not find any files that matched the pattern. For the pattern I left the default *.* for testing purposes. I have specified the file folder as \remoteserverfilesharesubfolder and also as \remoteserverc$filesharesubfolder and have gotten the same message. However when I map a network drive and set the file folder to the network drive it finds the files. Is this a permissions issue?

After I finish processing the file I want to move it to a new directory. Once this is deployed in production, the package will not be running under a domain account and probably won't have access to the network folder. Is there any way to specifiy in the connection manager itself that it should use a specific account to access the folder?



TIA,

Sabrina

View 1 Replies View Related

Backup To Network Drive Using Workgroup/Standard.

Jun 18, 2007

I am using SQL Server 2005 Express Edition. I am planning on upgrading to either Workgroup or Standard edition. While working with Express Edition I did find out that this version does not support backup to a network drive.
My question is:


Is it possible to backup directly to a network drive using a Workgroup/ Standard edition of SQL Server rather than backing up to a local drive and then 'copy and paste' to a network drive like the Express Edition.My other question is :


Given a database limit of 50GB, which one of the editions, Workgroup or Standard, will be appropriate for use.Thank you for your time and patience.
Regards
Berly Sam

View 4 Replies View Related

Backup To Non-local Hard Drive

Oct 19, 1998

I want to perform backups to a network drive. I need to know if I can access the backup drive via UNC. I have not been able to get it to work and, for now, I would just like to know if what I am trying to do SHOULD work.

For example I want to backup to device mdtnts_prod02LM2BackupNameBack.DAT.

Thanks,Bob

View 1 Replies View Related

Backing Up To A Non-local Drive/location

Dec 19, 2007

I've been working with SQL Server for a few years now and I've had quite a few cases where users cannot backup SQL to a network location or external hard drive. Why can SQL not do this? Is it some limitation of the speeds at which SQL needs to backup the information and the external hard drives/network drives do not meet the requirements?

View 8 Replies View Related

Linked Server For Mdb File On A Shared Network Drive

Jan 6, 2000

Hi

I am having an Access database on a shared network drive which has read/write access rights on the that shared network drive.
When I try to Access data through the linked server it gives me gives me a message box saying you do not have permissions to view the data.
Also if i try to use xp_cmdshell to copy over the mdb file to my local drive it say 'Access denied'

But when I copy (through command prompt) the same file to another network drive or my local drive where I have full control the linked server can connect sucessfully.

The problem is the i cannot have 'full control' permissions on shared drive where my database resides.

Has anybody encountered this problem....

Any help will be greatly appreciated.

Urgent
Puru

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved