Search results for query: *

Hello Can I have more than one witness in database mirroring? I found the term "Alternate Witness" for Outlook but not SQL. My client wants to have the database mirrored between 2 data centers and a witness at each data center. That way, if the one datacenter goes down, the mirror at the...

Hello I have questions about SQL Server and power outages. Is it better to leave SQL Server up when power is lost OR take the chance and shut it down at the risk of power being lost while it is still coming down. Also - what happens to SQL Server if our SAN is shut down first? Is there a...

Hello I am trying to document my sql server info How can I tell if my SQL installation is SQL Server 2008 or SQL Server 2008 R2? If I run SELECT SERVERPROPERTY ('productversion') AS Version I get 10.0.4000.0 and according to the SQL Server release history, 10.0 = 2008 SQL Server 2008...

Hello I am using SQL 2008 and have a project where a client is sending us transaction logs that we will restore on our server. Some logs, I am able to apply, some get the ... The log in this backup set terminates at LSN 8470802000000442300001, which is too early to apply to the database. A...

Hello - I just received these details and was hoping I could get a fast answer or at least the questions I should be asking... All internet traffic will be logged to ONE SQL cluster at a data center. Once the project is complete, the amount of data could reach 600-700Gb a month. Every...

Hello I am trying to identify which transaction logs are not correct to use. The BAK & 100s of TRN files are delivered on an external hard drive and restored here. The following works... if object_ID('tempdb..#x') is not null begin drop table #x end create table #x (BackupName...

Hello We have 2 servers on different networks and we are looking for a way to keep 3 databases on one server updated with the changes made to the 3 databases on the other server The destination server can be read only. One idea was to use log shipping but security was a concern - its assumed...

Hello I was brought in on a project where the plan was to take transaction logs from a vendors SQL database, FTP them to our server and apply the logs on our database on a daily basis. When testing, I was using the vendors BAK then applying the vendors logs - which worked - we thought we could...

Hello - This was a question asked of me as a DBA... Is there any way to quantify how many of these distinct transactions are completed on a daily basis? I looked into Profiler but still not sure these results will be accurate for what is needed. Here is what I have... Microsoft SQL...

Hello I am new to being a DBA and was informed that SQL Server updates have never been applied. I am currently running... Microsoft SQL Server 2005 - 9.00.3215.00 (Intel X86) Dec 8 2007 18:51:32 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build...

Hello - I am trying to use sqlcmd in a BAT file. Could someone help me out by letting me know why my input parameter doesn't work - below are my steps. FileA.bat works, FileB.bat does not. FileA.bat sqlcmd -S (local) -d DBA -Q"DBCC ShowContig With TableResults,ALL_Indexes"...

Hello Is there a way to tell which table and which records in a database have changed using the transaction logs? Do I need to purchase software to do this or can it be done with T-SQL? Thanks Dave

Hello - I am a newbie and trying to apply multiple transaction logs to a database. Below is my script - I wrote it weeks ago and do not understand how I can use 'NJnew' (this is the logical name?) in the command "MOVE N'NJnew' TO " RESTORE DATABASE [NJCCCS$DOE_Dev3] FROM DISK =...

Hello Could anyone recomend some good links, books, videos, etc for someone starting as a DBA in 2 weeks? My latest experience is roughly 80% writing T-SQL, 20% developing applications. I am least experienced with the network side. I own the MS Admin pocket consultants for 2000, 2005, 2008...

Hello In SQL2005, is there a tool or T-SQL statement I can run that will let me know what database a table, or view, stored procedure belongs to. Thanks Dave

Hello I would like to return the sum but I am returning individual records with "1" select (count (distinct( DirstatPolState+DirstatPolAcctNbr+PolSerialNbr+XdirstatPolicyYear) )) from dirstat_record_bk1yr where dirstatcoverage=94 and DirstatPolState = 37 group by...

Hello I have not used VB in the past - my windows programming was using Delphi. I have inherited an application that was written in a version previous to 6. We currently have Visual Basic/Visual Studio 6. The end-user is requesting a small change, but I am receiving an error when creating a...

Hello I am trying to create a report that will show all of the requests made by a manager and their current status. At the end I want to total the # for each status My SQL looks like this select upper(ac.contact) as 'Manager', AL2.Lookup_Description, count(*) as 'Count' from AT_date AD join...

Hello I was creating a TSQL statement that would tell me every stored procedure that contained a certain table. Next, I needed a way to select each database on the server. My question is - Does SQL Server Manager already have a utility to do this? declare @SEARCHWORD as varchar(500) set...

Heelo Is it possible to convert an integer to a date when my data looks like this 60,712 and is supposed to mean... 07/12/06 Is it possible to use CAST or CONVERT to detect this? Is it possible to assign a style? If so, how? Thanks Dave