Change Home And Data Directories
Jan 11, 2006I'm planning to establish a recovery plan for my SQLServer 2000
databases. How to change home and data directories?
ADVERTISEMENT
Reporting Services :: Change Home Folder Name?
Oct 1, 2015Can we change the name of the "Home" folder to something else? We have 15-20 instances of SSRS, and it would be real useful if I could display an instance name vs. "Home".
View 4 Replies View RelatedSetting Up Directories - Data Paths In Server?
Aug 4, 2015I'm curious if there's a "best practice" for setting up the data directories MS SQL will use for each operation? I've allocated independent disks for things like C: (OS), E: (DATA), etc etc etc but I'm not familiar w/ MS SQL to understand how DBA's commonly configure the folders under each unique disk for things like DATA, LOGS, BACKUP, INDEXES, and TEMPDB. Should I have an identically name folder as show below in my example?
You can see I've just mirrored the drive name to a new folder under the partition so data is being written to: F:DATA and E:LOGS. Is this considered correct / good practice? I assume naming the folder in each mount point to whatever I logically called the drive is correct but if I should change how I configure my drive paths above. I'm trying to learn common good SQL Server practices and while I work on properly installing SQL Server 2012/2014, I want to make sure I configure my partition names SQL will utilize correctly.
T-SQL (SS2K8) :: Create Numerous Directories On Server Using Data From Table
Apr 15, 2015SQL 2008
I have a table that has company id, attachment file name, folderexists columns.
First what I need to do is create a series of folder or directories on a networked server using the company id as the folder name where the folder name does not already exist.
Second I need to move files based on attachment file name and company id to the proper folder.
For those who want to know, this is a remediation project because of a bug in our application.
The application is supposed to created the folder based on company id and then put the attachment in that folder.
Master Data Services :: Access Denied In MDS Home Page
Aug 30, 2015I have installed MDS while installing SQL Server 2014 on my local machine ( windows 10). However when I try accessing the home page of Master Data Manager, it is giving access denied error. I am unable to access the Master Data Manager itself. MDS Database and Web Application are using same user account which is Administrator on the system.
View 2 Replies View RelatedMSSQL7REPLDATA: Too Many Directories!!!!
Aug 31, 2000we have snapshot replication set up between 2 servers. works like a charm... :-)
the problem is this: several agents are set to run every half hour (snapshot & distribution). every time they run, the agents create a new directory entry under MSSQL7REPLDATA (naming convetion: YYYYMMDDHHMMSS) and load it with files....
needless to say, after several days there are a LOT of directories. right now, we remove them manually, which is time consuming and a pain in the ass...
how do i configure SQL server to only make 1 or 2 dozen directory entries before starting to recycle them?
if this is a really simple fix everyone here knows, my apologies for clutering the board with a 'newbie' post. i'm not really a DBA, i was just 'volunteered'!... :-)
Protecting Sub-Directories (Using SQL 2005 DB And ASP.NET 2.0)
Mar 6, 2008I've been trying to look for information about using an SQL 2005 database with ASP.NET 2.0 - while there are loads of different articles coving configuring a database to use with asp.net, I cannot find anything on securing a sub-folder in my asp.net application. At the moment I am successfully connecting to, and validating users via a login page in my asp.net application, however, this is all pointless since I can still browse to the pages without logging in! I have tried putting in the usual <location> tags in my root web.config file and asp.net throws an error referring to my connection string, I have also tried adding a web.config file to the sub-directory, but that just uses the windows login, and I can't find anything that'll allow me to tie my own login page to it... Arrrgh! Any help will be greatly appreciated!
Thanks in advance.
Moving Database Directories..
Oct 16, 2000I have a machine where the SQL "data" directory was installed on the smaller drive instead of the larger drive. What do I have to do to move the existing databases? (Backup/restore, or detach - move it physically, then attach?)
Thanks, for the help
Backup To Multiple Directories?
Sep 13, 2007Has anyone ever had a need to backup to multiple directories? I am building a general purpose stored procedure to do various types of backups, and I was wondering if the need to do this is common enough to make it worth the effort.
Example of backup to multiple directories:
backup database [MyBigDatabase]
to
disk= 'D:BACKUPMyBigDatabase_db_200709131454_001.BAK' ,
disk= 'E:BACKUPMyBigDatabase_db_200709131454_002.BAK' ,
disk= 'F:BACKUPMyBigDatabase_db_200709131454_003.BAK' ,
disk= 'G:BACKUPMyBigDatabase_db_200709131454_004.BAK' ,
disk= 'H:BACKUPMyBigDatabase_db_200709131454_005.BAK'
with
init,
stats = 5
CODO ERGO SUM
SQL Install - No Images From Other Directories
Sep 30, 2007Hi
I'm pulling my hair out on this one..... Installed SQLServer 2005 Express and upscaled my website and intranet site that runs my photo image library.
All my thumbnails and images are in a local D drive, while my site root is in C drive. I.e. <img src="file:///D|/Images-WMASTER......etc
Images will now not display. I've checked folder & sharing permissions, IIS permissions, all the usual stuff, but still with no luck after 2 weeks #@%$$@!!
If I change to a networked folder, such as <img src="file:///S|/Images-WMASTER...etc then they show fine.
All I can think is that there is some permissions issue with SQLServer that I'm unaware of.
Your erudite advice would be greatly appreciated!
Thanks, Rob
Organizing Report Projects / Directories?
May 3, 2007Hey All,
I'm tring to figure out the best way to organize my reports.
When I create a new Reporting Service Project throught the 2005 .NET IDE, I'm allowed to have 1 folder in the project to deploy to. I've tried adding folders under the default Reports folder, but I haven't found a way to do this. I'd like to be able to add more directories so I can deploy them right to the server, and they will be in the proper folders, with the correct access rights.
A developer here has offered the approach of One Report - One Project. I don't want to do this because the reports have so much in common, like datasources, that I don't want to be flipping back an forth from one project to the next.
I did also look to see if there was a way to assign a dircetory to each report, rather than the project level, but I didn't see way to do that. I also, tried to add folder through the Windows Explorer and see if I could get around this restriction, but no luck there either.
Anyway, How is everyone else organizing they projects?
Eric Wild
New MSSQL Directories Created After Upgrade
Apr 14, 2008Hi,
I recently upgraded my Standard Edition SQL2005 to Developer Edition SQL2005 for the default instance (MSSQLSERVER) only. I used the following command line setup.exe commands to do the job -
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=S
QL_Engine PIDKEY=OHNOYOUCANTSEETHISSORRY SKUUPGRADE=1 /qb
then
start /wait setup.exe ADDLOCAL=Analysis_Server,RS_Server INSTANCENAME=MSSQLSERVER UPGRADE=Analysis_Server,RS_Server PIDKEY=OHNOYOUCANTSEETHISSORRY SKUUPGRADE=1 /qb
(Of course I used my real PID)
I then re-installed the SP2 patches. Everything seemed fine afterwards, until I tried to process a recent cube project in Visual studio. The DATEDIFF() function failed. So I found the problem (in this forum) that the VBAMDX assembly for my SSAS session was referencing an empty bin folder, and therefore could not process VBA functions in MDX.
Now I can fix this by editing the relevant XML file in the DATA folder and restarting my SSAS service but I am concerned about all the other stuff that could be referencing old folders.
Some of the settings e.g. DATA is still in C:Program FilesMicrosoft SQL ServerMSSQL.2OLAPData
but the bin programs are now in C:Program FilesMicrosoft SQL ServerMSSQL.6OLAPData
It seems that I now have 3 new installation folders - MSSQL.5, MSSQL.6, MSSQL.7 as well as the usual .1,.2,.3 since upgrading my Edition.
Why did it make these? What else may be out of wack on the SQLServer services? How can I make sure everything is properly setup?
I guess the problem could be that there is another instance called OFFICESERVERS on the computer (a WIN2003 server) which was created by the SharePoint installation by someother guy..
adv(thanks)ance
Mark W.
New SSIS, Info About Working With Directories Moving Files Etc
Apr 9, 2008
Hey,
What I am trying to achieve currently with SSIS is to view the content in one folder for example 'New' and if there is files in this then move it to 'Archived'.
Any nice liinks or tutorial or general advice you guys could give me ?
Making Virtual Directories For Sql Server 2005 Reporting Services
Mar 19, 2007I have sql server reporting services installed .
I have reinstalled the iis .
But now when i ever i reinstalled the reporting services i can't see any virtual directory in IIS.
SSRS installed successfully but no virtual directory
Now please let me help in making the virtual directories of sql server 2005 reporting services.
When I reinstall then if i try to connect with management studio I can't.
If i try to check surface area configuration i get following message
"Reporting services is not configured properly sqlsac"
Reporting Services Install Not Creating Virtual Directories In Default Web Site
Jan 29, 2008Hi,
I have uninstalled and reinstalled several times and I can't get Reporting Services to create the virtual directories in Default Web Site, instead it creates a new web site called Report Server with the virtual directories under that, this Report Server website points to C:Program FilesMicrosoft SQL ServerInetPubwwwroot. Any ideas as to why this happens? My Default Web Site is called Default Website from the initial IIS install , I am on XP Pro SP 2 with IIS 5.1.
This is an issue for me since I don't want to have on another site that doesn't have the aspnet mapings.
I am dumbfounded and can't figure out what to do to make it not do that with the default configuration option checked during install. Should I uninstall and reinstall again and not use the default configuration?
Regards,
Chris
Reporting Services :: ReportServer And ReportManager Directories Missing After Installation And Configuration
Aug 24, 2015I contact you because we installed Report Services 2012 and after configuring werb service URL, database, Report Manager URLs... the URLs linked to the Report server + Report Manager does not work.After searching in IIS, it seems that even if virtual directories are created, they are linked to directories which does not exist :- c:Program FilesMicrosoft SQL ServerMSRS11.ReportReporting Services does contain only LogFiles and RSTempFiles directories.
View 7 Replies View RelatedSQL Server Admin 2014 :: Change Data Capture(CDC) For Data Warehouse / Reporting?
Aug 12, 2015I have a requirement to implement CDC for 50+ tables to implement incremental data changes warehouse/reporting rather than exporting the whole table data. The largest table is having more than half a billion records.
The warehouse use a daily copy of OLTP db (daily DB refresh). How can I accomplish this. Is there a downside in implementing CDC just for the sake of taking incremental changes on the tables?
Is there any performance impact if we enable CDC on OLTP db?
Can we make use of the CDC tables on the environment we do daily db refresh so that the queries don't hit OLTP database?
What is the best way to implement CDC to take incremental changes for reporting.
SQL Security :: Making Data Change In Read Only Database Without Letting Other Users Update Data
Aug 6, 2015I want to make data changes in read_only database , that's why i must set database read_write. While database is at read_write mode, i want to be sure that no one makes change in database.
For this aim, i write the code below, but i suspect that after setting the database read_write, till the setting database
single_user ,is it possible get DML script from another user. Is the code below enough for this operation. Or is there another way?
Reminding: Read_only database can not be set single_user mode. That's why, first you must set database read_write.
The code;
use master
alter database xxx set read_write
with rollback immediate
alter database xxx set single_user
with rollback immediate
use xxx
update tablexxx set columnxxx=yyy
use master
alter database xxx set read_only
with rollback immediate
alter database xxx set multi_user
with rollback immediate
SQL 2012 :: CDC (Change Data Capture) Is Not Capturing Data Correctly
Apr 21, 2014I am using SQL Server 2012 and to me a part of data captured by CDC is not making sense.
I have a table called 'Schema.Table1', and I enabled CDC on it by running 'sys.sp_cdc_enable_table'. I see that a table called 'cdc.Schema_Table1_CT' got created which now gets an entry when ever I Insert, Update or delete a record in the original table.
Till this point every thing works fine.
My original Table has a NOT NULL INT column called 'AuditTrackerUserID' with a default value of 1996. My application does not provides a value for this column, but because the column itself has a default value, records get inserted without error.
When I try to execute the following Query I see multiple records with __$operation of 3 and 1.
SELECT * from cdc.Schema_Table1_CT where AuditTrackerUserID IS NULL
My expectation is that I should not ever see any record returned by this query because AuditTrackerUserID is a not null column, but I do.
Change Data Table From System.data Into Sql Query
Apr 4, 2007i someone had teach me how to write a query in datatable. however i need to get the data out from my database rather than the data table. can someone teach me how should i do it?esp at the first like.... like DataTable dt = GetFilledTable() since i already have set of data in my preset table i should be getting data from SqlDataSource1 right ( however i am writing this in my background code or within <script></script> so can anyone help me? protected void lnkRadius_Click(object sender, EventArgs e) { DataTable dt = GetFilledTable(); double radius = Convert.ToDouble(txtRadius.Text); decimal checkX = (decimal)dt.Rows[0]["Latitude"]; decimal checkY = (decimal)dt.Rows[0]["Longitude"]; // expect dt[0] to pass - as this is our check point // We use for rather than fopreach because the later does not allow DELETE during loop execution for(int index=0; index < dt.Rows.Count; index++) { DataRow dr = dt.Rows[index]; decimal testX = (decimal)dr["Latitude"]; decimal testY = (decimal)dr["Longitude"]; double testXzeroed = Convert.ToDouble(testX -= checkX); double testYzeroed = Convert.ToDouble(testY -= checkY); double distance = Math.Sqrt((testXzeroed * testXzeroed) + (testYzeroed * testYzeroed)); // mark for delete (not allowed in a foreach - so we use "for") if (distance > radius) dr.Delete(); } // accept deletes dt.AcceptChanges(); GridView1.DataSource = dt.DefaultView; GridView1.DataBind(); }
View 2 Replies View RelatedData Change
Dec 13, 2004Can anybody suggest the best way I can achieve the following.
To select anybody whose surname has change in the last week, and to automatically flag a code field with "C". :cool:
Change One Data To Another
Oct 18, 2007Maybe a strange query here for you guys but I would like to create a database where a user enters a code then they are transferred to another code - some explanantion:
SCD = Sony CD - expensive stuff
PCD = Phillips CD - expensive stuff
CCD = Cheap CD - cheaper stuff
User enters SCD then automatically the database would change SCD to CCD but it can also be that the user enters PCD and the database would change PCD to CCD. So when looking at the results for this table i would have 2 entries for CCD and also another 2 to say the user entered SCD and PCD. - hopefully that makes sense.
I need to know and understand how i should design the database to accomplish this so i can avoid any "gotcha" mistakes. Any thoughts on this?
Thanks
SQL Data Type Change
Jun 23, 2005I'm trying to compare 2 field in 2 different databases and one is varchar and one is numeric. Is there anyway I can tell SQL to treat the one thats numeric as varchar or convert numeric to varchar for the comparison string... I'm trying to run the following in query anaylzer:update crcwebauth.dbo.deviationmaster set ldate = (select max(qvdate) from crcbrio.dbo.invoice_tbl where dnumber = qvqote)It gives me error:Server: Msg 8114, Level 16, State 5, Line 1Error converting data type varchar to numeric.The DNumber field is numeric and the qvqote is a char field...
View 1 Replies View RelatedChange Data File Name?
Apr 20, 2001Hi,
I am not sure how to change data and log file name on existing database,
If it is oracle, I just need mount database and use alter database statement
to change data file name or location.
How to do it in SQL7??
Thanks
How To Change A Data File Name
Jun 3, 2004Hi All,
Is anyone can help me to change a existing data file into a new new name?
Thanks.
Grouping On Data Change
Feb 13, 2012I am trying to create a group on this data example
RecordNo, Item, Date,NULL
1, ABBB, NULL, 0 << first group
2, ABBB, 01-06-2011,NULL << first group
3, ABBB,NULL,NULL << 2nd group
4, ABBB, 02-01-2011,NULL << 2nd group
5,CAAA,NULL,NULL << 1st group
6,CAAA,NULL,NULL << 1st group
7,CAAA,01-01-2010,NULL << 1st group
8,CAAA,01-01-2011,NULL << 2nd group
9,CAAA,01-05-2012, NULL << 3rd group
Basically 3 groups on date, by item, so for each date change/ per part the group increments been playing with row_number partitions, but cant seem to get what i need.
Can't Change Data Structure
Nov 14, 2014I have a database (MSSQL). To demonstrate the problem let me show a fictive Tablestructure. I don't want to discuss about how to save the data differntly, because the structure is fix and I can't change it.To get this result I would do a sql query with a lot of joins like that:
SELECT firstname, lastname, email.value, phone.value
FROM Customer
INNER JOIN
(
SELECT Customer_Properties.id, Customer_Properties.value
FROM Customer_Properties
[code]...
I don't think that this is really performant and the SQL-Queries get very complicated. Give it a other methode for that? I can't change the data structure.
Change Data Display
Sep 28, 2005I have a db; that stores a company name; if the end user types in
The Stoneware Jar Company
I would like to display:
Stoneware Jar Company
All company names entered like that with no preceding "The"
How can I display something diff on my ASP Page? Possible?
Change Data Type
Oct 6, 2005I received a db2 data file that I converted to MS-Access. From Access Iran the upsize wizard to put the tabel in SQL. It put the table in okbut all the data types are nvarchar. I have a couple of the fields thatare cureny and some that are numeric.I need to change the data types from nvarchar to numeric type fields. Iam new to SQL so I do not know all the commands. How do I change thedata type?Michael Charney*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies View RelatedChange Data In MS Access
Apr 17, 2008I have a database with a table of 1,123 records that I need to change in a
hurry! The problem is I do not know how to do it.... For example there are 2
fields that are numerical and formatted buy currency 1 record reads 400 and
the other reads 400, but I need to double the amount for both fields and all
of the records. Please help..... Thanx in advance for any and all help..
When Data Sources Change...
Dec 14, 2006If I were to change a data source that many packages use (say, from box "SQL-2" to "SQL-1"), would I have to re-upload the packages that used that data source? Or would the packages already on the server receive that change somehow?
(currently realizing that most of the packages use package-local data connections instead of project-wide data sources...)
Thanks!
-Rob
Change Data Capture
Jan 13, 2006Again, looking for the best way to do this with SSIS.
I have a source table and I'd like to load it to a database daily, capturing what changed.
This is not a dimentional table but a fact table.
So, what I;d need to do for each record is to see if the record already exists (using business key) and if it does - compare some of the data fields and of there are changes - register it somehow and if not changes ignore.
Right now, the only two ways I see to do it with SSIS:
- Use Slowly Chaging Dimentions transformation
- Use Lookup and customize SQL, adding something like: WHERE key = ? and (field1 <> ? or field2 <> ?...)
I was wondering of there an easy way.
Dima.
How To Change Column Data As Row
Oct 28, 2007hi
I have a table like this
Username
Clicks
Impressions
Download
User1
12
23
43
User2
34
33
59
User3
39
88
77
User4
34
43
43
need to change the table like this
User1
User2
User3
User4
clicks
12
42
43
43
Impressions
43
43
43
43
download
43
43
43
43
Thanks
Ezhil