Viewing 15 posts - 2,986 through 3,000 (of 6,401 total)
You will need ISDATE(), LEN, CHARINDEX as a minumum to get this working.
But you should be doing your data validation in the front end, not within SQL.
January 8, 2013 at 4:09 am
Then you need to ensure that you setup transaction log backups otherwise the issue will keep happening.
Go back to the business and ask them what the recovery point objective is...
January 8, 2013 at 3:56 am
With difficulty
You could do a check in the string for the + or - symbol to indicate Offset
You could then do a check for a : to detail if a...
January 8, 2013 at 3:54 am
ananda.murugesan (1/8/2013)
Can we able to configure for LOG SHIPPING by two different systemt architecture?
source server
-------------
System type – windows 2008 R2 enterprise edition 64 bit operating system
Database – MS SQL SERVER...
January 8, 2013 at 3:52 am
Do you need the database to be in FULL recovery?
As I have said what is your acceptable amount of data loss? How much data can you afford to loose...
January 8, 2013 at 3:48 am
Yes if the destination is of the same SQL version or higher.
Log shipping doesnt matter if its 32 bit or 64 bit.
January 8, 2013 at 3:46 am
Sorry few more questions
Are both ReportServer DB's on the same SQL server?
Is SQL Server also installed in the cluster or is it a cluster dedicated to SSRS?
If the SQL server...
January 8, 2013 at 2:23 am
What is the setup?
Does each instance point to the same report server DB or do they point to different ones?
January 8, 2013 at 2:03 am
Do you do transaction log backups?
Do you need the databases to be in full recovery?
What is your acceptable amount of data loss? What is your recovery point objective? ...
January 8, 2013 at 1:37 am
John Mitchell-245523 (1/7/2013)
If this is an ad hoc query you wish to run against multiple servers, you might consider setting up a Central Management Server.John
+1 to that
January 8, 2013 at 1:31 am
If the destination has the required amount of free space to restore the database to it as it was backed up from the source server then yes.
So for example, if...
January 8, 2013 at 1:29 am
As you state that you are a new DBA, I would strongly recommend reading the Accidental DBA guide (link in my signature below) as it will cover some of the...
January 8, 2013 at 1:15 am
Can you run the package in SSDT and post the entire copy of the output screen?
January 8, 2013 at 1:12 am
What edition of SQL are you running, Standard or Enterprise?
January 8, 2013 at 1:11 am
IIF is used in SSRS, while it is not a valid T-SQL construct is is a valid Reporting Services construct
January 8, 2013 at 1:04 am
Viewing 15 posts - 2,986 through 3,000 (of 6,401 total)