Changing Folder For Databases To Reside In?

Aug 11, 2005

Can I change the folder that the databases reside in for my installation of SQL Server?  I would like to have them in a folder on another drive, but I can't seem to find where the path is configured.Any help is appreciated.

View 4 Replies


ADVERTISEMENT

Unable To Copy App_data Folder Databases On Production Server To A Different Folder Or Location

Sep 19, 2007

I dont alot about sql server 2005(Express edition). For debugging purposes i want to copy  the whole app_data folder(.mdf & .log files) on the production server to another folder on the same machine(or sometimes to a network folder).  So when i copy and try to paste this App_data folder to a new location, i get this error message
"cannot copy ASPNETDB: it is being used by another person or program. close any programs that might be using the file and try again."
After reading the above message, i close visual web developer, stop the website in IIS and stop the SQLExpress service on the server and try again but still get the same message.
So how can i make sure that all the programs accessing these database files are closed such that i'm able able to copy them to a different location.

View 2 Replies View Related

Changing The Default Drive And Folder For DB's

Nov 21, 2006

Hi;I feel like an idiot to be asking this,but how do I change the default drive and folderin which new databases are created?I've been looking all over Server Mgmt Studio,and I can't find anything. I'm thinking that someonecan tell me this off the top of their heads,or slip me a link to a web page.Thanks, 

View 2 Replies View Related

Changing HOME Folder Per User

Jun 18, 2007

I am wondering how I could do the following -

Right now the default folder is Home, what if I have two users User1 and User2, my folder structure is the following -
Home/User1
Home/User2

I want each user to only have access to their folder. That is easy to do.

Once both users have proper access to their folders they still don't have access to Home folder. In Report Builder when I do 'open file' it defaults to Home folder so I get an error. How can I specify the home folder to be User1 for that user and User2 for the second user? I know I can give them both browsing permissions to Home but it's not very elegant.

There must be a way to programmatically change the folder as soon as proper user logs in. Anyone knows how to do that?

Thanks.

View 9 Replies View Related

Changing The Temporary Folder Being Used By Reporting Services

Dec 19, 2007

Hi everyone!

I have a problem regarding the generation of report using SSRS (SQL Server Reporting Services). As I've read from other forums, the said service need access to the Windows temp folder, which by default, is found in C:WINDOWSTemp. The said path is found in either the TMP or the TEMP environment variable.This means that there should be sufficient access to this folder, in order for SSRS to properly generate the report. The problem is that my client, for security reasons, does not want to grant special rights to this folder, using the ASP.NET account. Is there any way that we can change location of the temporary folder being used by SSRS without having to change the value of the TMP and TEMP environment variables? thanks in advance

View 1 Replies View Related

SQL Server 2008 :: Changing Alt Snapshot Folder For Merge Replication?

Sep 22, 2015

I have a merge replication. Currently works fine. Publisher & Distributor are on the same server. I need to change the location of the alternate folder for the snapshot files.

I’ll probably just change it through the GUI, but would I use sp_changedistpublisher or sp_changemergepublication if I were scripting everything?

My real concern is the subscribers. Do I have to ‘tell’ the subscribers where the alt folder has been changed to? Do I just run sp_changemergepullsubscription on the subscribers?

View 1 Replies View Related

Can't Open 'databases' Folder

Jul 20, 2005

Hello, I just installed SQL Server 2000 on my home computer and amconnecting to a remote SQL server over the Internet. I can log intothe server just fine and see 7 folders including the 'Databases'folder. I can open up all of the other 6 folders but for some crazyreason when I double click on the 'Databases' folder, I can't open it!The hourglass appears and Enterprise Manager basically locks up. Doesanyone know what's going on?????Please email response to Join Bytes! as well as posting togroup.Thanks,Navin

View 1 Replies View Related

Display List Of Databases In App_Data Folder

May 16, 2007

Hi All,
The web site I'm working on will allow admin users to create a new database for each new client. I'm hoping to be able to keep all of the databases in the local App_Data folder, but I'm finding that I can't even find a way of generating a list of the databases in the App_Data folder.
The code I have is:Dim serverConn As New ServerConnection(".SQLEXPRESS")
serverConn.LoginSecure = True
serverConn.ConnectTimeout = 30
serverConn.Connect()
Dim sqlServer As Server = New Server(serverConn)

For Each db As Database In sqlServer.Databases
ListView1.Items.Add(db.Name)
NextThis does populate a list of databases, but not the ones in the App_Data folder - just those attached directly to the server.Any help on this will be greatly appreciated as it's starting to drive me nuts!Thanks,Paul

View 3 Replies View Related

Trouble Backing-up All Databases To Network Folder Using A Maintenance Plan

Oct 10, 2006

I have set up a Database Maintenance Plan that does a nightly backup of all of my databases (about 12 of them) to a network folder. The plan works for about 95% of the job, but most nights there will be at least 1 database which will fail with the following error...
BackupDiskFile::RequestDurableMedia: failure on backup device '\myfileserverBackupSQLDatabaseDatabaseNameD atabaseName_db_200610081749.BAK'. Operating system error 64(The specified network name is no longer available.).
I know that this is not a permission or storage problem, because it works for most of the job. And a database that fails one night, may work fine the next night only to have a DIFFERENT database fail that night, and sometimes all databases work 100%.

Is there a way to fix this problem? And if not, is there a way to be notified of which specific database in the maintenance plan is failing. The message on the job itsself is very non-descriptive and I have to manually search the logs to find out which databases were successful & which where not. It is very time consuming. Any help with this would be greatly appreciated.

View 5 Replies View Related

Changing Databases In While Loop

May 1, 2008

I am trying to run an update query for 2 identical databases. I am using SQL 2000. Here is the code for the loop.
--*****************************
USE DB1
Declare @Locnum1 integer
set @Locnum1 = 0
While @locnum1 < 2
BEGIN
Update OpenJob
Set JobN = 15
WHERE (OpenJob.CustomerN = 183)
USE DB2
Set @Locnum1 = @Locnum1 + 1
END
--*****************************
When I run this code it runs the update query on DB1 twice instead of switching to db2. Any help you can provide would be greatly appreciated.

Thanks,

Jason

View 14 Replies View Related

Changing Databases In An Stored Procedure

Aug 24, 1999

Hello all,

I have discovered that you cannot use the "USE" command in a stored procedure to change to another database.

Is there any way I can change to another database within a stored procedure besides calling another stored procedure on the database I want?

Thanks,

Nev.

View 1 Replies View Related

Changing 'Filename' Attri. When Creating Databases

Jul 13, 2006

Obadiah writes "hello,

I am a newbie to developing .net applications unfortunately my boss and my colleaques think i am a pro (interview went too well) and i would like to get at least this months paycheck before am fired....so i here's my dumb question:

I want to create a SQL database from my vb.net application using stored procedures, however i want to be able to set the Filename attribute ('Filename = C:Program FilesMicrosoft SQL ServerMSSQL$SARDONYXINSTANCEData estdb.mdf') by means of a input parameter to the stored procedure. like so...
Filename = @databasepath.

HERE is what i have:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE rico_dbasescript
@Databasepath varchar(100) = 'c:program filesmicrosoft sql servermssql$sardonyxinstancedataSardonyxrioctestdb.mdf' , @Databaselogpath varchar(100)= 'c:program filesmicrosoft sql servermssql$sardonyxinstancedataSardonyxrioctestdblog.ldf'
AS

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Sardonyxrioctestdb')
DROP DATABASE [Sardonyxrioctestdb]



CREATE DATABASE Sardonyxrioctestdb
ON
( NAME = 'Sardonyxrioctestdb_dat',
FILENAME = @Databasepath,
--FILENAME ='c:program filesmicrosoft sql servermssql$sardonyxinstancedataSardonyxrioctestdb.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sardonyxrioctestdb_log',
FILENAME = @Databaselogpath,
--FILENAME ='c:program filesmicrosoft sql servermssql$sardonyxinstancedataSardonyxrioctestdblog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO


The above procedure works fine when Filename = 'c:program filesmicrosoft sql servermssql$sardonyxinstancedataSardonyxrioctestdb.mdf'
but bombs out when Filename = @Databaselogpath.

Thank you in advance."

View 2 Replies View Related

Destination Resets When Changing Selected Databases

Sep 19, 2006

I discovered that everytime I need to add a database to my backup Maintenance Plan, after I select the new database from the drop-down of databases, the Destination automatically resets back to a default location.

I'm assuming this is a bug that will be resolved at some point, but in the meantime, I need to see if there is a way I can deal with this permanently. I am not the only one adding databases to the backup routine so I can't verify that this setting is properly changed every time we have a new database (which is about once a week).

Thanks in advance.

View 10 Replies View Related

SQL Server Admin 2014 :: Changing Compatibility Level Of System Databases

Jun 27, 2014

I have just upgraded a test server from sql server 2008 sp3 to sql server 2014 inplace upgrade. The compatability level of master database has not upgraded. It was showing 90 and the rest of system databases got updated to 120. Is it fine to update the compatibility level of master database ? Any precautions need to taken??

View 1 Replies View Related

Can SQL 2000 &&amp; 2005 Reside Together

May 13, 2008

Word of warning! I'm new to the forum and relatively new to SQL Server. Please excuse my lack of knowledge for proper terminology.

I have SQL Server 2000 installed locally on my laptop and have been using it several months. Everything works fine. I also need to have SQL Server 2005 installed. I tried to install 2005 to a new instance name and got errors on Visual Studio Integrated Development Environment 2005, SQL Server Books Online, and SQLXML4 modules. I have the log files if someone needs to see them. Something common to all 3 module errors is: HRESULT: 0x80070020

Question 1: Can 2000 and 2005 reside on the same machine without conflicts? or do I need to uninstall 2000? I would prefer to have both installed if that's possible.
Question 2: How do I fix the 2005 install? Just reinstall it? or do I have to uninstall 2005 and then reinstall?

Thanks in advance for any help.

View 3 Replies View Related

SQL Server Admin 2014 :: Changing Drive Letter For System Database And User Databases

Oct 18, 2013

I have system database and user database file are present in G,H and W drive.The process is going to be - copy data from G to S, H to T, W to U. Rename G to X, H to Y and W to Z. Rename S to G, T to H and U to W. Reboot the servers. The original G, H and W will then be X, Y and Z. The old S will be the new G, old T will be H and old U will be W. My question is that after doing this whether my SQL server will start or not

View 8 Replies View Related

Where Connection Pool Reside In Momory?

Sep 26, 2007

Hi All, 
Where Connection pool reside, is in client side(in .net framwork) memory or at server(in sql server) momory or at both side it maintains pool information?
Best RegardsImran Zubair
 

View 4 Replies View Related

The .mdb Database File Must Reside On The Server

May 19, 2000

I read in MSDN that

"The .mdb database file must reside on the server. data_source is evaluated on the server, not the client, and the path must be valid on the server."

What does the above means..... I do have to have MDB file reside on server ?

If reside on server where the MDB file should go & HOW ?

In the dirctory of //mysql/binn ?, wondering how

Regards

View 1 Replies View Related

Can SQL Express 2005 &&amp; MSDE Reside On The Same Box?

May 11, 2007

Is the installation of MSDE and SQL Express 2005 on the same computer a supported configuration?



Many thanks

View 1 Replies View Related

Data Reside In Memory And Accessed Via CLR Database Objects.

Nov 7, 2007

Hi,
I want to manage memory relational data in the memory(Insert, delete, return) and manipulate the data via SQL 2005 and CLR database objects.
The gool is to manage a table that relatively has a lot of inserts and deletes which takes a lot of IO operations and i want to reduce it. the data itself is not permanant each row deleted from the table after 15-20 minutes.
I looked at the extended stored procedure and other CLR enable objects and it seams that they all return data from the database itself.
How can i return data that is reside in the memory?
Thanks.

View 2 Replies View Related

Integration Services :: SSIS WMI Event Watcher Check For New Folder In Existing Folder

Jul 2, 2015

I know a WMI event watcher can be used to watch for a new file being added to a folder. However, I need to check for new folders being added to an existing folder. I haven't been able to find a post on doing this. Is there a way in WQL to check for a new folder being added instead of a new file? I've used SQL for years, but am new to SSIS.

View 2 Replies View Related

SSIS Or SQl Agent Job Moving From A Network Folder To A Sharepoint Folder - Errors...

Oct 31, 2007



Ok,

I have a network folder called A

I have a SharePoint (2007) Document Library site called B. Web Client is enabled on the server and B is mapped as a Drive (let's call it Y for this discussion)

I want to move documents in A to B. Easy enough, right? Not so....

I first started by creating a batch file that issues a COPY \A \Y /Y at the command prompt. Viola! Worked Great!

I then moved that command to a SQL Agent job as a CMDExec statement (exact same statement) and attempted to run it.....CRASH! It found the files in A but then said "The system cannot find the path specified"

Ok, so I tried it in SSIS. CRASH! Checked the error log. Same thing...

So I then checked the account under which the SQl Agent was running (special domain account for all our SQL Servers). Thinking it might mater I changed it to run under my name (I'm in Domain admin). I also ensured I had permissions to the SPS 2007 library as well. (I did).

Ran again! CRASH! Same error....

So, I created a batch file , placed thec ommand in the batch file and ran that from the command prompt! Viola! Worked Great.

So, I was thinking of how ingenious I was as I pasted my C:RootCopy.bat into my SQL Agent job. With a big grin on my face I right clicked and picked "Start Job at step".......CRASH! Same error.

Does anyone have any ideas on this ???????????????

Thanks,
Stephen

View 3 Replies View Related

Need To Create And Access A SQL Server Database That Will Reside On An External Hard Drive.

Apr 9, 2007

 
 I need to create a SQL server database and add some tables to it. Then access it with a C# application. The problem is that the new SQL server database and it's tables must reside on an external hard drive. How do I point SQL server to this external drive, so that I can create a database on this drive and then create tables and access data on it?
 
 

View 7 Replies View Related

SQL 2012 :: Does Secondary Replicas In AlwaysOn Have To Reside In Windows Cluster Servers

Sep 18, 2014

I know now that AlwaysOn feature HAS to be installed/configured on a Windows Clustering environment, BUT the secondary replicas, like the Disaster recovery replica residing in a different Data Center HAS to be also in a Windows Clustering environment or can it reside on a SINGLE SQL Server INSTANCE?.

View 6 Replies View Related

Can I Use The Foreach Loop To Obtain The Sub Folder Names Within A Folder?

Sep 4, 2006

I have a set of folders with the following structure:

MainFolder

1999

SpreadsheetA.xls

SpreadsheetB.xls

SpreadsheetC.xls

2000

SpreadsheetA.xls

SpreadsheetB.xls

SpreadsheetC.xls

etc.

Is there a way that I can use the foreach loop container to loop the sub folders? My plan was to get the folder name and path into a variable, use this to build the connection string for each file in this folder, carry out the upload for that folder, then move onto the next folder and do the same thing, but I cannot see a way to do this.

Thanks,

Sam

View 2 Replies View Related

Moving Csv File From One Folder To Another Folder

Mar 28, 2008

I am having problem with moving a file from one folder to another folder. Here is the detailed scenario:

I want to move a input.csv file from shared input folder to shared archive folder. i am using the below code to do this.
declare @inpath varchar(100)
SET @inpath = 'move "\abcdefINPUTinput*.csv" "\abcdefARCHIVEarchive.csv"'
EXEC @filestatus = master..xp_cmdshell @inpath
but the problem was it was cutting the input.csv file from INPUT folder but not pasting it in the ARCHIVE folder.
I really appreciate if anyone can help me to solve this or anyone can tell some workarounds.

Thanks,

View 20 Replies View Related

Linking Tables From Different Databases Or Querying From Multiple Databases

Dec 10, 2007

Dear Readers,Is it possible, like in Access, to link to tables in other SQL databases that are on the same server? I have a query that I originally had in Access that queered from multiply databases. It did this by having those other tables in the other databases linked to the database that had the query. 
 

View 3 Replies View Related

Service Broker Not Working For Restored Databases (SQL 2000 Databases Restored On 2005)

Jan 24, 2006

I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased using the query "select is_broker_enabled from sys.databases where name = 'newdbname' " It was 1. I even tried the ALTER DATABASE SET ENABLE_BROKER. but it didnt work.

When i tried the sample on a newly created database it worked fine.

Is there any solution to make the restored database to work for service broker.

Thanks

Prashanth

View 3 Replies View Related

If C:folder.. Contains Data Then Do..

Oct 10, 2001

hi, I am curious to know if I can do the following from within a store procedure.

If I have a folder under c drive c:clientand would like to check if there is any files inside the client folder, how can I write such code in sql into a store procedure. I want to do some actions like expoft table data (bcp) into the client folder if there is no text files..... I do appreciate your help

Ali

View 1 Replies View Related

Run All .sql Files In A Given Folder?

Jun 4, 2008

Hi,

say I have th following in my post-deployment script:

:r ..ScriptsFolderScript1.sql
:r ..ScriptsFolderScript2.sql
:r ..ScriptsFolderScript3.sql
...

How can I do the equivalent of

:r ..ScriptsFolder*.sql
??

I've tried the above and the syntax is not supported.

Your help is much appreciated! =)

View 3 Replies View Related

Binn Folder

Mar 12, 2008

What would be the impact of replacing the SQL 2005 90 ToolsBinn folder with the SQL 2000 80 toolsinn folder?
A colleague of mine did this in a SQL 2005 production environment so that he could still use isql.exe. Unfortunately, users are getting kicked out of the database and I'm thinking the binn folder may be a factor.
Thoughts?

View 5 Replies View Related

Get Files In Different Folder Using Sql

Aug 9, 2006

Hi All,I have a multiple files, but they are store in different directory onthe server. I want open those files and insert it into the databaseusing bcp.Example files structure dir:\xyz123abc ext1.txt\xyz123abc ext2.txt\zyz123999 ext2.txtbcp "dabase" in \xyz123abc ext1.txt -c -S"servername' -Usa-Ppassword -T".is there away to loop througth each dir, get the files, excecute thebcp, then go to next folder.Please help. Thanks in advance.Ted Lee

View 2 Replies View Related

SSIS Bin Folder

Nov 16, 2007

Could I delete all packages from Bin Folder? Will it effect anything?

Best Regards,

View 7 Replies View Related







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