Search results for query: *

Hi - I ran into an odd issue when configuring log shipping. The transaction log backups work but, the copy job fails with the following error: 2010-08-16 11:19:00.97 Copying log backup file to temporary work file. Source: '\\xxxx\PROD_db\PROD_db_20100816165505.trn', Destination...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

Quick question.... I have a report with many subreports that prompts for windows credentials and the server and instance against which it is to be run which works great with windows authentication. I need to use SQL authentication on some servers (no trust between domains). The problem I have...

Hi, I've run into an issue when I create a local group on my laptop (32 bit o/s) that is running SSMS 2008 Microsoft SQL Server Management Studio 10.0.2531.0 and export it. I can export the group however when I try to import the group on another server or laptop I receive an error message...

I am trying to create a space usage report and the challenge I have is the date is stored as a varchar in the column in the table. I can convert this easily in sql (so that when you group and order the data it does so correctly when there is data from the prior year) however I cannot get the...

I have a sql job that has 2 lines of code to rename 2 separate files. The problem I am having is the job only runs the first line of code and then reports success. If I put the code in a bat file it runs fine. move /Y S:\"Microsoft SQL...

I have 2 tables - one contains application information that has been pulled in from the extended properties and looks like: Application information Table: DBName Application Description test1 MS_Application Test Application test1 MS_Description Used for...

I have a quick question... we need to pull data from 2 databases and combine it in a report. Is it better to create a view that is select * from dbname.dbo.table in the reporting instance or just query the table directly using .... from dbname.dbo.table in the reporting instance?

Does anyone by chance have a script that will run through and check the sequence numbers on the transaction logs in the log shipping directory? We are required to delay our log shipping apply by 24 hours due to limitations on legacy system recovery, and I don't want to find out we are 24 hours...

Hi, We are considering using database mirroring and snapshots for our DR. Here is the scenario - We have a SQL 2005 cluster of which we would mirror 2 databases to our DR site. The thought was to take a snapshot every 24 hours since for now the legacy systems can only recover to that point...

I have used the following stored proc before (run against the publisher) to generate the custom replication stored procedures that you then run on the subscriber (so inserts, updates and deletes can use a stored proc to perform the changes) sp_scriptpublicationcustomprocs 'publication name'...

Hi, I am relatively new to SSRS and have a question - I deployed the Performance Dashboard reports (post sp2 on sql 2005) in my SSRS 2008 reporting services and they work well for 1 instance. I would like to let the user select the server they want to run the report against - is there a way to...

Hi, I am just starting to look at the data collector that came with sql 2008 and have read that it does not work with sql 2005 instances. Is there a way to leverage this tool with some tweaks to run against sql 2005 instances? Anyone tried this yet? Any advice is appreciated as 90% of our...

Hi, I have run into an odd SQL 2005 sp2 cluster install issue. I did the install of standard edition, applied the sp2 and when I go to fail over the instance (currently running on one node) it fails with: The resource database build version is 9.00.3042. This is an informational message only...

We keep seeing the following message in our preproduction cluster that is using a pull subscription for a reporting database: Replication-Replication Distribution Subsystem: agent %S% scheduled for retry. Query timeout expired We checked the basic performance counters and didn't see much...

Quick question, We are considering trying to set up a sql 2008 central policy management server and run the data collector on the same server. I am having a hard time locating documentation specifying the hardware requirements for this type of a configuration. Has anyone tried this yet? Any...

Quick question, When you take a full backup of a database and restore it on another server does it rebuild all the indexes during the restore process? or will the fragmentation that existed in the database prior to the backup come over to the new server? Thanks,

Hi everyone, Is there a way to have a monthly job check to see if the last weekly job succeeded prior to executing? Basically I want to run the monthly job if the last weekly job was succesful but, if it failed I don't want it to run. I know the sysjobhistory table contains the job and...

I have a large db (over 300 gig) that I need to set up transactional replication on. I wanted to use a backup for initialization and followed the steps of creating the publication, marking it to allow initialization from backup, taking a backup, restoring the backup then I get a little stuck...