Move distribution data/log files to another drive

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - table column extended field properties Hi, I am not familiar enough with the options to have a preference Actually I don't know what the options are. I'm trying to write in C# clr code, but whatever works. also, What is smo Regards Boyd Tag: Move distribution data/log files to another drive
  - 2
    - Checking to see if a record exists and if so update else insert It's an awesome article - and I used this method in my 1st SSIS package. However, if number of records is high (over 1000) the OLE Update Command performs slowly. So in that case you might better off loading source data to staging table and creating Stored Procedure which Updates then Inserts (and Deletes) data in the destination table. Using Lookup transform in the way described in article is quite efficient (compared to other methods like merge join) - and can be useful in a variety of situations Tag: Move distribution data/log files to another drive
  - 3
    - DISTINCT COUNT WITH NULL VALUES (GRAND TOTAL) Maybe you need to sum the project counts for each professor in the selection, like: Amnt_Projects Sum (existing [DimProfessors].[prof_id].[prof_id] , [Measures].[ Distinct amount of projects ]) Tag: Move distribution data/log files to another drive
  - 4
    - Cannot Login i guess you are using User Insatance. this is a common problem in userinstance of sql server express Refer this link : http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx if you are not aware of User Instance , post back the connection string used in your application. I think , you don't really need to use Userinstance. in that case you can use normal connection string. Madhu Tag: Move distribution data/log files to another drive
  - 5
    - SQL Server dropping comma in German language Thanx Arnie for your input. The response is timely. I did some digging in my code, did some testing, and found this: The culprit in this observation was a save routine I was employing: - The routine first assigns each value to be stored in the database to a variable of variant datatype. - After doing some checking to ensure data correctness, ADODB writes the value to the database - When the regional language is English, ADODB seems to convert the variant variable to the datatype expected by the database -e.g 29.15 gets written as 29.15 - When the regional language is German, either ADODB or the database gets confused, and the comma-decimal delimeter is dropped - e.g. 29,15 gets written as 2915 - When the regional language is German and I change the variable to the correct datatype before writing to the database (e.g. vba.csng(var1)), the correct value gets written to the database - e.g. 29,15 gets written as 29,15 The feature of ADODB to determine the correct datatype in the database I found was a plus as it greatly simplified some of my code. However, now that I see the problem in a global environment, the feature seems to be liability since it doesn't seem to be robust. Or maybe my code was just risky. Either way, I'm updating my code to explicitly format the value to match the database. Thanx for you help! Tag: Move distribution data/log files to another drive
  - 6
    - Maximum length of an expression If only that were true! Alas, my longest expressions are to provide a sub-title built of the selected values of a pile of multi-select (and other) parameters, and these require the use of such functions as Count, which cannot be called from code behind. Debugging these things is a painful experience (as is debugging code behind) -- am I alone in wishing fervently for better debugging Thx Helen Tag: Move distribution data/log files to another drive
  - 7
    - AMO Role Creation Hi, The server is my localhost. How do i know if my project is in online mode I already deployed and processed it before i created the roles in AMO and run it. In SSMS, where can I find there the role Thanks a lot! cherriesh. Tag: Move distribution data/log files to another drive
  - 8
    - Proclarity analytic Views without using sharepoint Thanks a lot. Moe Min Tag: Move distribution data/log files to another drive
  - 9
    - static variables in a SQLCLR stored proc seem to get reused from execution to execution of the sp is it fair to assume then that the sp's method(s) itself is also remaining in "memory" (ie not getting reloaded) between executions, unless SQL had to reclaim that memory from SQLCLR previously Tag: Move distribution data/log files to another drive
  - 10
    - Add list as parent for rectangle in rdl Hi! I have a report designed with all the tables in the rectangles on the rdl. Right now, I need add "list" control on the top of those rectagles(including all the tables) so all the rectangles have list as parent I don't want to start over to just for adding the list. I was trying to edit report xml file to add the "list" on the top of rectangles but the compiler complains. The rectangle property has "parent" field ,which is "body" right now. How can I make it's parent as "list" This field is grey out so I can not change it in the property window. Any idea Thanks. Tag: Move distribution data/log files to another drive
  - 11
    - Printing in Reporting Services hangs No - this is not the same issue - none of the fields are very long (all less than 40 characters). And it happens when I print any of the reports. Any other ideas Tag: Move distribution data/log files to another drive
  - 12
    - MICR Font Issue When Exporting to PDF We don't embed fonts in the PDF. This means the font needs to be installed on the machine you are opening the pdf on. Tag: Move distribution data/log files to another drive
  - 13
    - Stored Procedure adding new row Try this: Code Snippet create procedure InsertProc ( @inputdata varchar ( 100 ), @orptnbr varchar ( 100 ) output ) AS Begin DECLARE @wrptnbr varchar ( 100 ) INSERT INTO MyTable VALUES ( @inputdata ) SET @wrptnbr = 'REPORT-' + convert ( varchar ( 15 ), scope_identity ()) UPDATE MyTable SET RptNbr = @wrptnbr SET @orptnbr = @wrptnbr End Tag: Move distribution data/log files to another drive
  - 14
    - Member Property length limitation I had checked it. It has LongWVarchar(2000). Tag: Move distribution data/log files to another drive
  - 15
    - SQL Server 2005 Evaluation Install Error Peter: How do I check the system %temp% variable Where is it Tag: Move distribution data/log files to another drive
  - 16
    - Custom Control Flow Item Issue When you execute from SQL Server Mgt Studio, actually it runs from your system and not on server. Hence you will need SSIS installed on your box to run it locally. This should give you some more insight http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx Thanks Tag: Move distribution data/log files to another drive
- Next
  - 1
    - Data Source and Connection Manager jh0483 wrote: Hi all, What I think is that when I'm making a new connection manager, what's really happen is a copy of the data source, is that correct That's correct. I don't use them either. You can run into additional issues when the properties either from the connection manager or from the data source changes; you will start receiving annoying notifications/warnings that your data source and connection manager are not sync every time you open the package. Tag: Move distribution data/log files to another drive
  - 2
    - Query Execution failed for dataset error / the syntax for " " is incorrect I dont wish to hard code the values. It should be dynamic Tag: Move distribution data/log files to another drive
  - 3
    - Month's end Or, depending on your data, you may want to use more optimal LastChild aggregation function. Tag: Move distribution data/log files to another drive
  - 4
    - Backup File Name Dear Satya, I tried Maintenance plan, but i am getting the following error: Creating maintenance plan "SAP_Backup_Full" (Error) Messages Create maintenance plan failed. ------------------------------ ADDITIONAL INFORMATION: Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476 ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476 When I checked the Link, No information is described there. Can you please suggest me. Thank Imran Hasware Tag: Move distribution data/log files to another drive
  - 5
    - CONTAINS and WHERE Clause Combination taking too long Hi Jens, Thanks, i was already affraid that it will be the case. In this case what you suggest Because LIKE '%%' is killing my performance. Any suggestion will be appreciated. Tag: Move distribution data/log files to another drive
  - 6
    - stored procedures, compile or not Stored procedures are the best way to go. It all depends on your data including WITH RECOMPILE in the sproc definition. Try it both ways. You can have a job run sp_recompile [ @objname = ] ' object ' several times a day. Tag: Move distribution data/log files to another drive
  - 7
    - Add connection error: 40 Hi i just reinstalled windows, and installed visual studio .net 2005 and the Sql server. But when im trying to add connection, select my computer at Server name, type a databasename then pressing OK i get this message: An error has occured while estabilishing a connection to the server. When connection to SQL server 2005, this faliure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Names pipes provider, error: 40 - Could not open a connection to SQL Server) Does anyone know what todo herman Tag: Move distribution data/log files to another drive
  - 8
    - is it possible to connect to SQL Express without network? Arnie Rowland wrote: Yes. SQL Server will still work the same as when you are connected to the office LAN. Since you log on with your domain credentials (they are cached on the laptop), the same credentials are used to gain entry to SQL Server. Ok, thank you. I did experiment on 2 workstations. On one machine ist working good, but on the second machine (no netowrk connection) when I tried to connect to the sql server I have a problem: SSMS is ocnnecting ok Application gives me message: cannot generate SSPI context. What can it be ... Thank you Tag: Move distribution data/log files to another drive
  - 9
    - Cannot completely install/remove SQL Server Express Thank you for the above references, but following up on my previous post, I am stuck attempting to remove SQL server 2005 manually as described by http://support.microsoft.com/kb/909967 . Because SQL Server 2005 Express will not uninstall or reinstall from ARP and the error messages I get are different from the procedure outlined in KB909967, I would appreciate further help in cleaning up this installation. The status of things are as follows: Directory structure: C:/Program Files/Microsoft SQL Server/ has /80, /90, and /MSSQL.1 subdirectories. Error logs: A search of C: shows no Sql_uninstall.log or Sqlredist_uninstall.log ARP installed programs status is as follows: Microsoft SQL Server 2005: ... Will not remove from ARP list. Components installed shows no Server instances, workstation component cannot be removed. Microsoft SQL Server Setup Support files: ... Installed - did not attempt to remove yet. MSXML 6.0 Parser: ... Installed - did not attempt to remove yet SQLXML4 - SP2 KB925672: ... Installed - did not attempt to remove yet SQLXML4 - SP2 KB927978: ... Installed - did not attempt to remove yet The following were successfully removed from ARP: Microsoft SQL Server 2005 Backward Compatibility: removed successfully Microsoft SQL Server Native Client: removed successfully Microsoft SQL Server VSS Writer: removed successfully A registry search shows the following GUIDs under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall... {50A0893D-47D8-48E0-A7E8-44BCD7E4422E} - Microsoft SQL Server Native Client {53F5C3EE-05ED-4830-994B-50B2F0D50FCE} - Microsoft SQL Server Setup Support Files (English) {A4512736-8D63-4298-9271-5329931FA46B} - Microsoft SQL Server Management Studio Express {C0D2F614-5CE5-4DCB-8678-E5C9AF7044F8} - Microsoft SQL Server VSS Writer {no GUID shown} - Microsoft SQL Server 2005 When I use the following command to try and remove Microsoft SQL Server VSS Writer, start /wait msiexec /x {GUID} SKIPREDISTPREREQS=1 /l*v c:\sqlredist_uninstall.log I get an error message "This action is only valid for products that are currently installed" Any ideas Tag: Move distribution data/log files to another drive
  - 10
    - Transaction log backup error has this database in Database mirroring Madhu Tag: Move distribution data/log files to another drive
  - 11
    - Email as csv using Database Mail Thanks, That sorts out that problem but I'm still having major problems with emailing as a csv. Can anyone help Thanks, Steve Tag: Move distribution data/log files to another drive
  - 12
    - convert timestamp to datetime You couldn't convert timestamp to datetime. Timestamp is a row version not datetime of row change. When you add or update row timestamp increase Tag: Move distribution data/log files to another drive
  - 13
    - Unable to make changes to disconnected recordset howabout cloning the recordset instead rsPackages.clone then do the manipulation Tag: Move distribution data/log files to another drive
  - 14
    - What is wrong with my codes to connect VB.net to sql server 2005 Express database? I did modify as you suggested, the 3 error remain the same, and here is their message: LinkSqlServer2005Express\Form1.vb(15) : error BC30188: Declaration expected. That means I did have syntax on the following codes: (or missing Import) sqlConnection.Open() ' ----> error cmd.ExecuteNonQuery() ' ----> error sqlConnection.Close() ' ----> error Thanks Tag: Move distribution data/log files to another drive
  - 15
    - I am new this SSIS, Please help me. thanks for reply. I am asking is there any free documents and tutorials are available in any free sites. thanks Babu Tag: Move distribution data/log files to another drive
  - 16
    - No Parameter Pane when Reporting in 2005 against a 2000 AS Cube OK, I fixed it. For those that are interested. SSRS 2005 will not support the parameter pane when connecting to an SSAS 2000 cube. The steps you need to follow are as follows: 1. Create a connection (data source) to your AS2000 cube using OLE DB connection (In my case I used version 8 - Provider=MSOLAP.2) 2. Add a new dataset - this will be the old text based MDX editor rather than the snazzy new SSRS 2005 AS GUI so you will need to put your MDX hat on 3. Construct a base MDX query with the filter hard coded, e.g. Code Block SELECT NON EMPTY { [Measures].[Area Controlled] } ON COLUMNS, NON EMPTY { [Developer].[Tracked].[Actively Tracked], [Developer].[Tracked].[Actively Tracked].CHILDREN } ON ROWS FROM [QMSLand] WHERE ( [Time].[Quarter].[Quarter].[Q1 2007]) 4. Set up a second dataset to return the values for your parameter list e.g. Code Block WITH MEMBER Measures.NullColumn AS 'Null' SELECT {Measures.NullColumn} ON COLUMNS, {[Time].[Quarter].[Quarter].Members } ON ROWS FROM [QMSLand] 5. Create a Parameter in the norma way, specifying the values to be selected from the query in 4. Let's say we call it Quarter 6. Finally, edit your initial MDX query to include the new parameter as opposed to the hard-coded value e.g. Code Block ="SELECT NON EMPTY { [Measures].[Area Controlled] } ON COLUMNS, NON EMPTY { [Developer].[Tracked].[Actively Tracked], [Developer].[Tracked].[Actively Tracked].CHILDREN} ON ROWS FROM [QMSLand] WHERE ( [Time].[Quarter].[Quarter].[" + Parameters!Quarter.Value + "])" Important things to note about step 6 a. The command must be enclosed in quotes i.e. ="....mdx here..." b. Note also the way the parameter reference is wrapped in speech marks c. Ensure you have your complete dataset before wrapping the command - you cannot add fields once the command is enclosed in parentheses d. The command must be a SINGLE line (no carriage returns)...so I used notepad to ensure this Painful and very lightly documented... but a solution none the less Tag: Move distribution data/log files to another drive

rjrlane

I haven't found the definitive answer on how or if this can be done without removing replication. I'm thinking ALTER DATABASE modify_file is the way to go. Anybody know if this will work or a better way to go about it

Thanks

Top

Re: Move distribution data/log files to another drive

Gary Chen

"Alter database" should work. There is a similar posting.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1619608&SiteID=1

Gary

Top

Re: Move distribution data/log files to another drive

rjrlane

I saw that one. The client ended up adding a file to the new drive and shrinking the original.

Thanks

Top