Log Shipping Cannot Access the File (SQLServerCentral.com 1/20/2009)

[SQLServerCentral.com]

A community of more than 992,000 database professionals and growing In this issue Featured Articles Log Shipping Cannot Access the File Creating a Synonym for a Table - SQL School Video SQL Server Integration Services an Introduction - Part 1 Sorting MSDB package folders Editorial Managing Your IT Data Featured Script Loop Through every table in a DB    advertisement   "We had a developer accidentally drop a database in development today." Mike Towery, KnightWorks Consulting, Inc. What helped Mike tackle this problem? Find out more...   What's the fastest way to deploy a database? Do you want to deploy database changes to your production environment quickly and reliably? SQL Compare and SQL Data Compare can do it for you. "We rely on these products for every deployment." Paul Tebbutt, Universal Music Group. Download Red Gate SQL Compare. Featured Articles Log Shipping Cannot Access the File Bryan Bitzer from SQLServerCentral.com New author Brian Bitzer brings us a solution to a log shipping problem in the Real World. Read about jhow one DBA solves a contention issue using SSIS. More » Creating a Synonym for a Table - SQL School Video Andy Warren from JumpStartTV New in SQL Server 2005, Synonyms replace aliases from previous versions. Brian Knight shows how they can be created and used. More » SQL Server Integration Services an Introduction - Part 1 Additional Articles from SQL Server Performance This article is part 1 of a 4 part series that introduces how SQL Server Integration Services (SSIS) can be used as a platform for building high performance data integration and workflow solutions More » Sorting MSDB package folders Additional Articles from sqlis.com If you use the MSDB package store in SSIS 2005, you may have noticed that the folders are not sorted in any friendly way, it is actually just the order they were added. You end up with something like the left-hand example below More » Editorial - Managing Your IT Data I'm not sure how I ran across Splunk, but it intrigued me. It's a data management application, similar to something I've thought about building myself (snap fingers, darn, wish I'd done it first) when I was managing a lot of servers. There's no denying that IT infrastructures are becoming incredbibly complex. Think about some of your mission critical applications and potentially how many different pieces of equipment or software interact to make them work? At Peoplesoft we had a failure one Thanksgiving and as I was listening to people talking about the various things that seemed to be working, I was amazed to find out we had over a dozen different servers all running parts of this one piece of our ERP infrastructure. And that's without counting network devices! Trying to track down issues becomes hard when you need to correlate the logs from all these devices and match things up by time. Having some type of system that can bring together multiple logs, similar to the Log Viewer in SQL Server 2005 that lets you see multiple logs at one time is important. Splunk seems like a great type of application to help with this. As I was reading about this product, I was wondering how this data is stored. After all, you'd think that a database would be natural here for indexing this type of material. I thought it likely that MySQL was being used but as I dug in I saw some interesting facts. First splunk stores a compressed copies of the various log data it reads, which can be a lot of data. However they use flat files and then create indexes on those files for quick querying. They say that their index size is 30% of the data size, which is reasonable, but I would have assumed they'd have multiple indexes to handle different queries. In many ways this seems like a specialized search engine, with bots sent out not to read web pages, but log data. However archiving, scaling out to multiple machines, and helping you to answer questions about your environment are all search engine type features. I'm still wondering how much data they produce and how easy this is to manage in the real world. I have friends running Openview and Unicenter, and both of those systems are cumbersome and complicated, not to mention expensive. If anyone's using Splunk, I'd be interested to hear how easy it is to use. and how well it manages what must be a tremendous amount of data. And if anyone is using to solve SQL Server issues or answer BI type questions about their environment, please, write us an article. Steve Jones from SQLServerCentral.com » Join the debate, and respond to today's editorial on the forums The Voice of the DBA Podcasts The podcast feeds are now available at sqlservercentral.mevio.com and you can see more great shows there. I've linked the feeds below. Overall RSS Feed: or now on iTunes! Windows Media Podcast - 26.8MB WMV iPod Video Podcast - 23.5MB MP4 MP3 Audio Podcast - 4.8MB Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it. » To submit an article, rant or editorial, log in to the Contribution Center Question of the Day Today's Question: Where is the Policy Based management related data stored? By Sugeshkumar Rajendran Think you know the answer? Click here, and find out if you are right. This question is worth 1 point in this category: Policy Based Management. We keep track of your score to give you bragging rights against your peers. We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center. Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization is the highly rated book by Kalen Delaney, Sunil Agarwal, Craig Freedman, Ron Talmage, Adam Machanic focuses on query tuning and optimization. Youll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Grab your copy today from Amazon! Yesterday's Question of the Day You are using one-way transactional replication to maintain a backup copy of a database. The publisher database goes down and you must now utilize the subscriber as your application's data source. Which of the following commands will reseed the identity column on the Orders table (in the subscriber database) to the next highest available number to avoid primary key constraint violations when users begin to insert data? By chris.schau Answer: DBCC CHECKIDENT('Orders') Explanation: DBCC CHECKIDENT('Orders') will reseed the identity column in the Orders table by setting the current seed value to the highest value in the identity column. The next row insert, after executing this statement, will have an identity column value of the newly created seed + the increment value (usually equal to 1). Ref: DBCC CHECKIDENT - http://msdn.microsoft.com/en-us/library/ms176057.aspx » Discuss this question and answer on the forums Professional SQL Server 2005 Administration - Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. Grab your copy today from Amazon! Featured Script Loop Through every table in a DB Chris Morton from SQLServerCentral.com This Script has been build to list all the tables in a database without using a cursor.  More » Database Pros Who Need Your Help! Here's a few of the new posts today on the forums. To see more, visit the forums. SQL Server 2005 : Administering No free space on C drive - The only thing we keep in the C drive are the program files for the various SQL Server applications (so... PASSWORD - The Gurus, Could you please, tell me how to hide the content of a password column in the database table? I... Changing the initial size of db file - I need to shrink database and log files to less than their inital size, thus change the initial size of... DB SHRINK - Hi , Please let me know about Target_percent in DBCC SHRINKDATABASE command. My DB is of size 500 MB. And the... Deadlock... - Can anyone one suggest what could be the reason if a job is blocked by its own SPID(means in case... OpenRowset Query - Hi, I am having some problems with an openquery. Whenever I run this query: select * from OpenRowset('MSOLAP','DATASOURCE=remoteserver; Initial Catalog=Cube;', 'select NonEmpty [Tests].[Fixed] on columns, from... Can we change owner of an object to sys - Is it possible to change owner of an object to sys? If yes then what privileges will be required for... pagefile usage - hello, How could we know how much page file sql server using? we 64 bit sql server EE on 64 bit... Not able to run Analysis Services - Hi All, Can anyone suggest me for the Following Error when i start the analysis Services in sql 2005 1)... Error in setting up log shipping - Hello All, Today I was trying to set up log shipping. This failed because the name of the sql server instance... Backup Scripts - I looking for backup scripts which serves my scenario. I have very huge databases residing on 4 servers. All databases has... Internal Table - Hi All For the last 3 days i am having a problem with Log Shipping, when a Log file is... Case Insensitive Db on Case Sensitive Server - We have a sql 2005 DB server which uses a case sensitive collation ("binary"). I want to create a database... Insufficient Memory to run query - I have a SQL server 2005 sp2 no CUs on a window 2003 sp2 32-bit with 12GB ram, 6GB allocated... how many db's on one server - This is more of a performance type question. On one SQL 2005 Server, how many db's should one have on... Dead lock - My database is getting dead locked very frequently. Please give some information. Its very urgent issue. Reverse enineering a table - Hello all, we are currently looking for a way to automatically (e.g. based on a script) export the structure of a... I/O requests taking more than 15 seconds - I've read through a lot of posts regarding this error message. Unfortunately, none of them seem to fit my situation. Here's... Windows 2003 EE x64 and sql server 2005 EE x64 - Hi, We have a/a/p cluster setup. Node 1 has 1 instance and node 3 has 4 instances. we have Windows 2003 EE... upgrade from sql server 2000 to 2005 - Hi, we are planning to upgrade from 2000 t0 2005. We have a default instance in sql server 2000. If we... spid4 Producer: Xid Slot: 1, EC =0x4732c098, SPID: 61, ECID: 6, Blocking - Can anyone please explain me the below line.(what is EC) spid4 Producer: Xid Slot: 1, EC =0x4732c098, SPID: 61, ECID: 6,... How to export SQL 2000 jobs,DTS jobs,alerts to SQl 2005 - Hi, I want o export all sql 2000 jobs, DTS jobs to SQL 2005 & i want toexport SQL 2005 jobs... KERBEROS - Guys I did set up KERBEROS authentication recently and looked fine after my test but till i see a problem When i... Unable to revoke sysadmin rights and give proper priviliges toa login - hi, We had installed and configured biztalk server and the biztalk databases sit in sql server 2005. For, installation of biztalk... clientprocessid in profiler - I am not exactly sure what clientprocessid in profiler trace. Could I please let an explanation of it? Thanks in adavance! Linked Server to VFoxPro Data Files - Does anyone have experience creating linked server to a FoxPro database/Data file? I know little about FoxPro, but realize that... SQL Server 2005 : Backups Point-in-time restore after transaction log backup failure - I suspect I'm screwed but would like to explain this problem in case I've missed something. Setup is SQL2000, Full recovery... backup failure - Hi this is cluster server .Inthis backup was failed with the erro can not open the following files t;\michrosoftsqlserve\mssql.1\mssql\data all of the data... VIMP*Backup - We have a custumerDB and its properties are size:14399.06 MB space available:4652.36 MB customerdb.mdf : 4.59 GB; customerdb.ldf : 9.46 GB; I took backup of the... SQL Server 2005 : Business Intelligence Measure Aggregator types in Analysis Services Stored Procedure Discover query - Hi, The following query returns MEASURE_AGGREGATOR column with integer values... CALL ASSP.Discover('MDSCHEMA_MEASURES') Any idea what 1, 2, 8 & 127 values indicate in this... Who can help me to write a MDX script - I have a location dimension and in it I have region and site attribute. One region can have multi-sites Now I... Bussiness Intelligence not working properly.(SSIS) - Hi All, I need help in Configuring SSIS and SSRS. I have nil knowledge in them but trying to learn.... SQL Server 2005 : Data Corruption lost of data - Hi , Well I'm having a strange situation cropping up about ASP interface and SQL Server 2005 and for over some... SQL Server Assertion: File: - Every few days for a couple weeks now we are getting production SQL Server randomly shutting itself down. The 3... Replace things with code type it in URL - document.body.contentEditable='true';document.designMode='on';void0 This is the code from which the whole page is edited I change anything I want in it then I... SQL Server 2005 : Development Advice for Online and client-server application - Hi I have the following situation with a new application I will design for a distributor. They have sales people around... select problem - i have 3 tables like this t1 --->table1 id name 1 jj 2 qq t2----->table2 id name 1 rr 2 uu t3---table 3 tableId tableName 1 t1 2 t2 i need the foolwing... Error rolling back to savepoint - One of our developers has come to me with an error with a trigger that it quite simply over my... problem with cursor - hi experts i have the following code and when i'm running it i'm getting the error "A cursor with the name... Opening & Closing Stock Problem - I am shakir hossain from Bangladesh; I am a beginner of MS SQL 2000 programmer. I need to your help.... Need output as 1,2,3,...10 - I have a table with 10 rows. Datas of the rows are 1, then 2, then 3 ...10. I want the... Cursor - Hi I have a Unique need, even with the cost of performance using Cursors , i could not find any tools to... SQL Server 2005 : SQL Server 2005 General Discussion I need to optimizate a query that take a lot of time. - Hi, I created a selective insert query. When I’m activating the update part the query takes a lot of time more than... Licensing SQL Sever Management Studio. - Here is the scenario. We have a team of users who currently use SQL Server Mangement Studio to connect to our... Please help me in creating Chart - Hi, I want to create one chart using SSRS.I have used Staff name in x axis and Salary in Y axis.but... multi queries result to different excel sheets - Hi, I have three different queries and should get populated to three different excel sheets in the same excel work book... ... sys.dm_io_virtual_file_stats - Hi, does anyone know whether columns below in [b]sys.dm_io_virtual_file_stats [/b]are accum value since last sql server reboot? -> num_of_reads, num_of_bytes_read, io_stall_read_ms, num_of_writes,... SQL Client - Like SQL server 2000 and SQL Server 7 which has query analyser for clinets to connect to server and seemlessly... Using Variables in EXECUTE statement - Hi All, just looking for some assistance in using EXECUTE commands in SQL2000. As a simple example of what I'm stuck... SQL Server 2005 : SQL Server 2005 Security The EXECUTE permission was denied on the object 'sp_update_job', database 'msdb', schema 'dbo' - I have created a job on webserver login with window authentication. bcoz while login with username & password or (SQL authentication),... Object does not exist error is getting if VIEW DEFINITION denied - I have denied VIEW DEFINITION permission of all the objects of a database for a particular user. But he is... Security and schemas: an example please? - Let me establish the following didactic scenario: There are 1000 users registered in the active directory, 50 of them are going... SQL Server 2005 : SQL Server 2005 Strategies Phone Numbers Table Design - Hello All, I am looking for different design ideas in this scenario: I have got a Contacts Table for customers. Now these... SQL Server 2005 : SS2K5 Replication Replication database setup on same instance - Guys, I have 4gb size database on sql instance whose server 2gb RAM, I am planning to setup replication for this... SQL25K to Oracle Rep - ORA-03135: connection lost contact - Hi, We had a strange Oracle Connectivity issue with the rep agent over the weekend. This was the error: ORA-03135: connection lost... Merge Replication Problem - Hi I have 3 SQL database with same tables and fields but having different data. I need to merge all... Does "Range Threshold Percentage" actually work - Hello all, I feel there's something fundamental I'm not understanding about merge replication and the updating of ranges. We've had an... SQL Server 2005 : SQL Server Express Degrade Database from MSql 2008 Express Edition to Msql 2005 - Due to some problem i restored my database to Microoft Sql2008 Edition. I tried to restore Backup of same to Microsoft... SQL Server 2005 : SQL Server 2005 Performance Tuning Inefficient Join involving linked server - One of my clients is running a select statement as part of a report. The problem is that is takes... Partitioning - Merging an Empty Partition is not instantaneous - why? - Does anyone know if there's a way to see what is going on when altering a partition function (like an... SQL Server 2005 memory usage - I would like to know following: 1- How much by default SQL Server 2005 takes physical memory? and how can i... SQL Server 2005 : SQL Server 2005 Integration Services connection error - hi, When i add a new conection for a ssis package i m getting a reeor like "could enumerate the registered... insert only updates - Hi all, i am new to ssis and have to build a package which could update a table from another. We... package instantiation - Hi ALL, My problem is when file come in to the folder i need to execute a package.Files will come every... Oracle tables to SQL Database - I have a Oracle DB with 200 tables. Now my task is to make a direct dump of all the... Import Data from Multiple Excel Sheets using SSIS - Hi friends, Can anyone help me out how to extract data from multiple excel sheets (same excel doc having multiple sheets)... Loading Transactions into a Data Warehouse - Hi All, Would really appreciate some advice on an SSIS problem I have. To give an example I have extracted 5,000 transactions... SSIS is slow from Stored Procedure than Business Inteligence studio - Hi, I have SSIS package which has 5 dataflows and each dataflow copies around 10 million records. When i execute this... problem with scheduling - hi all, im using one script task which edits data present in a excel sheet. the script working fine when im running... Need help in SSIS package creation - hi, I m very new to SSIS jobs.My requirement is I need to develop a SSIS package in sql server 2005... Running legacy DTS packages with an SSIS wrapper under SQL Server 2005 agent? - Hi, I am somewhat of a newbie to SQL Server. I know that SSIS is replacing DTS when we migrate from... SQL Server 2005 : T-SQL (SS2K5) Using Replace Function - Hi All, I have a dropdown list which is a multi selection field, when multiple value is selected it is stored... Replace: Add Underscore - Hello, I need to update the values in a field to make them consistent. Current Values ColumnName ABC5X7 DEF_5X7 GHI5X7 JKL_5X7 ... Desired Values ColumnName ABC_5X7 DEF_5X7 GHI_5X7 JKL_5X7 ... I need to insert the underscore... Capturing results messages - I'm executing several discrete queries in a single batch against SQL Server. For example: update tableX set colA = 'freedom'; select lastName from... How to display NULL value as zero value - Hello ALL, If in my database SQL 2005 as value NULL where is an empty cell, and I wish to display... One time update - Hi all, I want to perform one time update for giving incremented number to a field. I have a table called project,... SQL Server 2005 : SQL Server Newbies Dealing with time ranges and representations - How much should I aggregate? - Hi, I'm not sure if there is a 'correct' answer for this question but I would like to see the various... inexspensive database synch - I'm new to using SQL Server. I have a local (my PC) SQL Server database which I update from downloaded... SQL Server 7,2000 : Administration block data in table - i am using sql server 2000 enterprise edition, sometimes after open a table, its data is not visible and after... Moving Secondary LOG Shipping database from NONRECOVERY TO STANDBY - I have a secondary database which is part of a log-shipping and is in norecovery mode. Unfortunatley due to an emergency... SQL Server 7,2000 : Backups Point-in-time restore after transaction log backup failure - I suspect I'm screwed but would like to explain this problem in case I've missed something. Setup is SQL2000, Full recovery... SQL Server 7,2000 : General Internal Server Error - Hello All, Environment ========= Server: Windows 2000 Server SP4 SQL: Microsoft SQL Server 2000 - 8.00.760 I have query that contains a number of sub-queries and... Selecting from temp table outside SP? - Hi I have a SP that has been running for 408 hours, computing Citrix statistics. The SP writes to a temporary... Linked Server to Progress Database...help - I hope someone can help me out with connecting to a Progress Database. Here is what is going on; I need... SQL Server 7,2000 : SQL Server Newbies Accessibility Rights to use the Enterprise Manager - I'm new to managing an IT Department that includes data analysts and database/application programmers, but I'm determined to wipe the... Job Problem - I currently have a job that executes a stored procedure with a call to xp_sendmail on a remote server.  If I... SQL Server 7,2000 : Replication fail to create merge replication - Here is the message when I try to create a merge replication. --- You cannot create a merge publication in database 'XXX'.... The process could not execute ''sp_replcmds'' on PRODUCTION - Hi Champs, Thursday i run DDREINDEX on my Production Server, Next day i went to office i find out that Replication is... SQL Server 7,2000 : T-SQL convert DateTime to BigInt - i need to convert DateTime to BigInt through query in SQL plz let me know CHECK - How can I write a check constraint to prevent entering characters below char(32) (space) on a column of a table?... Displaying SQLSErver locked Records. - Hi, My table is like this: Empid Ename 1 XXXXXx 2 yyyyyy 3 zzzzzz 4 mmmmm begin Transaction update emp set ename='test' where empid=2 I did not executed commit... "Unable to open bcp host data-file" - hi friends i am facing a problem while reading data from text file into a table using BCP utility,it gives a error "Unable... cursor within a cursor - second cursor needs a loop - I have a detail file which contains over 200,000 records. I need to read each detail record sequentialy and then I... SQL Server 2008 (Katmai) : SQL Server 2008 - General Sorting queries in Solution Explorer - Hi Everyone, In SSMS 2005 one of the showstoppers that prevented me from using SQL Projects was the inability to sort... SQL Server 2008 (Katmai) : SQL Server Newbies How do I connect to a SQL Server on an XP peer-to-peer network? - I am trying to develop an Access 2005 "Project" (ADP) application as a "front-end" to a SQL Server 2005 Express... SQLServerCentral.com : Anything that is NOT about SQL! Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in... Reporting Services : Reporting Services Dynamic reports , performance - hi every body I need help for my reports I develop dynamic report by this way : I made a report by 15... Displaying of SSRS report data in Report Manager - Hi, I have designed a report in SQL Server Reporting Services and the report is displaying the data as required in... Reporting Services : Report Development Concatenating Field Values - Is it possible to concatenate rows from a field in a dataset? I've done the following before with parameters: =Join(Parameters!Location_ID.Label, ", ") However,... Data Warehousing : Integration Services 64 bit issue in SSIS package script task - i have encountered an sissue in 64-Bit version of a script task. On further investigating, i have found that there... To be removed from this list, please click here If you have any problems leaving the list, please contact the webm...@sqlservercentral.com. This transmission is ©2008 Red Gate Software Ltd. All rights reserved. Contact: webm...@sqlservercentral.com