Answer Questions

• RavindraPatil Database Backup

  Hi, I want to know how to take a database backup in sqlexpress from command line. Can some one help me Thanks. At it's most simple, you'd use something like this: SQLCmd -S .\SQLEXPRESS -E -Q " BACKUP DATABASE AdventureWorks TO DISK = N 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\AdventureWorks.bak'" This isn't teribly flexible or robust, so you're more likely going to want to write a backup script and call that script file rather than just typing in a simple T-SQL command. Read the BOL topic on BACKUP for information about the various options. You can find a general overview of database backup here . Jasper Smith, one of the SQL Server MVPs, has put t ...Show All

• chongqing Package Runs in 1 minutes in Visual Studio but takes 5+ (sometimes hanges) as Job

  I have an SSIS package that when run from Visual Studio takes 1 minute or less to complete. When I schedule this package to run as a SQL Server job it takes 5+ and sometimes hangs complaining about buffers. The server is a 4 way 3ghz Xeon (dual core) with 8GB ram and this was the only package running. When I look in the log I see that the package is running and processing data, although very very very very very slowly. Has anyone else experienced this Thanks for your help Marcus I don't klnow what is going on with my system. The above package has ran find since I posted this message. I'm now having issues with stored procedure that is being ran from a job. I can run the SP from Manag ...Show All

• tstarbuck RESTORE LOG with different recovery path

  I'm trying to RESTORE LOG with a different recovery path. Is there a way to do this I'm getting the below error. I know I could RESTORE from the beginning, but need to RESTORE the log file to the same database schema but different database and server. What steps do I need to do This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Se ...Show All

• Johnnylightbulb hierarchy in SSRS 2005?

  is it possible to use a hierarchy (e.g: CountryCode, PostCode, CityName) as basis for a report parameter I would like the user to have the possibility to drill down from e.g.: "Country = 'Austria' - PostCode '1010' - CityName 'Vienna'" and after that view the report with the selected parameters. possible yes - no - maybe regards pamike My bad... you only need that crazy text parsing function when trying to pass multi value parameters to a stored procedure. If your result set is not generated using a stored procedure, all you need is the SSRS parameter name like this: SELECT CityName FROM AccountGeography WHERE PostalCode IN (@PostalCode) with SSRS 2005 you would only need ...Show All

• DamsDev2007 CAn't run DTSX from Visual Studio

  I can create and edit DTSX packages in Visual Studio 2005, but I can't execute them because the start button is grayed out. Can someone help I am able to run them using the execution utility, but that's a hassle. Kathy Are you editing the packages stand-alone or are they part of a project/solution You can only execute them if they are in a project. -Jamie ...Show All

• k2sarah NEWBY question - filtering dates

    Im not sure how to explain this or if this is the correct forum but here it goes. I have created a report from a view that gives me court hearing dates on a defendent.  When I run the report/view I get two different dates for the person such as, 12/14/2006 and 12/15/2006.  How can I get it to show only the later date (12/15/2006)   I pull information from a mainframe that almost always gives me 2 different dates, but we only need the most recent date. Here is my query for the view SELECT     dbo.CASES.CaseID, dbo.CASENUMBERS.CaseNumber AS Arrest_Number, dbo.CASENUMBERTYPES.CaseNumTypeCode AS Arrest_NumType,              &n ...Show All

• LeeC22 Variables set via Script task don't change

  I've got a container with two variables: xxxNextFile and xxxLastFile , both with EvaluateAsExpression = False. My container has a dataflow followed by a script task followed by another dataflow. The first dataflow starts with ae existing raw file source from variable xxxLastFile and wants to write output to a new raw file from variable xxxNextFile . The script component then sets the value for xxxLastFile equal to the value of xxxNextFile and generates a new value for xxxNextFile . The final dataflow component does pretty much the same as the first one, i.e. it uses xxxLastFile for the source and xxxNextFile for the destination. I've got two package scoped variables pkgFolderTemp and pkgCurrentTime that I use to come up with a unique file ...Show All

• MitchellH How to detect bad data out of fact in tables and how should we deal with them before integrating them to the data warehouse?

  Hi, all here, Thank you very much for your kind attention. I am having a query about how to find out bad data out of fact (I mean the value is out of the defined data field type) automatically in a large transactional table, and how to deal with those bad data before integrating them into the data warehouse Is there any third-party softwares to deal with detecting bad data and dealing with them Thank you very much in advance for any helpful and advanced guidance. With best regards, Yours sincerely, Hi Adam, That's great to learn about controlling incoming bad data, but how can we check for the existing bad data. Kindly share your views on this. Any small help is also appreciated. Thanks a lot ...Show All

• Troy L SQL 2k5 Std. not installing, PA655502.CAB isn't found

  Does anyone know where I might find this CAB file Where do I put so the installation can find it MSI (s) (58:F0) [16:59:30:375]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI56F.tmp, Entrypoint: StartCache Action start 16:59:30: StartCache. StartCache: Error 0x80070490: failed to get cabinet: PA655502.CAB StartCache: Error 0x80070490: failed to set state for cabinet: PA655502.CAB I originally posted my problem on 01/19/2007, look for that post if you'd like to see the complete log files. thanks, Wnz The cab file does exist in the location you suggested, so the media (CD) doesn't seem to be corrupted. Hey Wnz, What's your setup media, are you installing from network share, locally copied cache or ...Show All

• SOAC Selecting version of remote SQL instance into local variable?

  Hello all, I'm a bit new to SQL Server and T-SQL (my background is in DB2 ), so hoping you can help me with this. I'm writing a T-SQL script that's hopefully going to scan a bunch of SQL server instances and record the results. We've got a mix of SQL2K and SQL2K5 instances, and for part of my script I only want to run something if the remote instance is SQL2K. I'd tested this on my local PC with several instances created and it worked fine. When I try and run it for instances located on other servers it barfs . From what I've found from looking up the error message it looks like I've got myself a loopback -- but I don't know how to get around it - any ideas please DECLARE @tempdata TABLE (scratch sql_variant) DECLARE @debug tinyi ...Show All

• Robert Gregory Garfinkle parameter passing with blanks - help required

  Hi, I am having a curious problem with parameter passing between reports. I have 2 reports the first report gives employee name, Department and in the second report I have employee details. If the user clicks on the Employee name in the First report it should go to the second report and display the details. My problem comes if suppose the employee name is “Don King” when the parameter gets passed it does not recognize the space between the name and throws an error saying King not recognized. Would appreciate if anybody could suggest as to how I can pass the name with spaces in the report parameters. Thanks and regards PMNJ am passing the parameter thru the r ...Show All

• ajeeshco Will FTP and File System Tasks run in Workgroup Edition?

  I have a package that does an FTP and some File System Tasks. It runs perfectly fine in BIDS but doesn't want to run via SQL Agent. Is the SQL Server Edition the problem Or you could try to use FTP component in script task Or you could try to create batch file and execute that Another problem might be that your Package Protection level is set to "EncryptSensitiveWithUserKey" (default option) - and your Job runs under administrator account - in which case it is not able to decrypt FTP connection User/password The solution I use is to set the ProtectionLevel to DontSaveSensitive and provide User/pass from config file. I suppose it could be. But then do you have any error messages ...Show All

• XTend Bug in Management Studio : Cannot add procedure article for heterogeneous transactional replication

  Hi, I'm setting up a heterogeneous transactional push replication with Sybase ASE 12.5.3 as subscriber. With management studio I try to create an procedure article with following properties Copy extended properties : false Destination object name : pGS_RefuseRequest Destination object ownere : dbo Action if name is in use : keep existing object unchanged Replicate : Execution of the stored procedure Create schemas at Subscriber : false When I save the article and then the publication I got following error message: Can not add artice 'pGS_RefuseRequest'. Object was not found on server. Check if this object exists on the server. (Microsoft.SqlServer.Rmo) That's realy strange because the wizard offered the procedure ...Show All

• robinjam Real World: Backup Strategy and implementation, how?

  Real World: Backup Strategy and implementation, how A quote: “Real World: Whether you back up to tape or disk drive, you should use the tape rotation technique. Create multiple sets, and then write to these sets on a rotating basis. With a disk drive, for example, you could create these back files on different network drives and use them as follows: //servername/data1drive/backups/AWorks_Set1.bak. Used in week 1, 3, 5 and so on for full and differential backups. //servername/data2drive/backups/AWorks_Set2.bak. Used in week 2, 4, 6 and so on for full and differential backups. //servername/data3drive/backups/AWorks_Set3.bak. Used in the first week of the month for full and differential backups. //ser ...Show All

• maximc Extracting a specific amount of data from a field

  I am working with a particular field in my SQL database that has the addresses of all our customers. Each part of the address is seperated with a Carriage return but is shown in the database as just a single line of text. I need to show this in my report as a seperate field for each part of the address (A1, A2, A3 etc..) however I am unsure as to how to extract the data up to each carriage return and then from that one to the next one. I can use the following which obviously just extracts the data up to the first specified character length but this doesnt really help very much. SELECT LEFT(ADDRESS, X) AS A1 FROM GTW_BUSINESS_PARTNER Has anybody got any ideas how this can be done. Many thanks From a performance point of view i ...Show All