Viewing 15 posts - 301 through 315 (of 486 total)
DECLARE @sqlcmd nvarchar(4000)
SELECT @sqlcmd = '
BACKUP DATABASE [DBNAME] TO
DISK = N''D:\BACKUPs\DBNAME\DBNAME_1_' + CAST(CAST(getdate() AS DATE) AS NVARCHAR(100)) + '.bak'',
DISK = N''D:\BACKUPs\DBNAME\DBNAME_2_' + CAST(CAST(getdate() AS DATE) AS NVARCHAR(100)) + '.bak'',
DISK...
October 28, 2013 at 10:50 am
Your options are very limited in that scenario.
1. You could keep the enviornments in sync using a custom ETL solution ran on demand to make all the changes but...
October 28, 2013 at 7:32 am
In your test enviornment does the data need to be read \ write or can it be read only?
October 28, 2013 at 5:19 am
What synchronisation method are you using for Node3 (DR)?
October 28, 2013 at 5:11 am
Proving your SSRS install is not on shared storage and it is configured correctly with its database connection string to the clustered database it will not make any difference to...
October 23, 2013 at 11:27 am
Remember the hosts are neither active or passive as both are up and connectable regardless of whether or not they are the active node for the clustered SQL install.
Think of...
October 23, 2013 at 10:27 am
I suspect the problems trying to use the dir comman on a unc path. I can't test this as I'm not on a computer but I am sure that...
October 23, 2013 at 10:18 am
I couldnt help but notice you are using an administrative share:
\\hostname\d$\SQLBACKUP\database
Accessing D$ on the host can only be done by accounts that are a member of the local administrators group...
October 23, 2013 at 9:46 am
One potential solution is to have your SSRS databases installed on your clustered SQL Instance.
Then on the physical node install the SSRS Server, each configured to use the same shared...
October 23, 2013 at 9:40 am
Yes I believe so, the collation issue I am not sure about though. You would have to test for that.
If your using the unicode data types it should...
October 22, 2013 at 9:27 am
Personally I would be very wary of letting another DBA administer your environments. How sensitive is your data, how complex is your environments, will it always be the same...
October 22, 2013 at 7:49 am
Accoriding to other information I have found it appears not:
Mixed versions are supported, but:
•Distributor version must always be equal or newer than Publisher
•Subscribers for transactional replication can be within 2...
October 22, 2013 at 7:24 am
It could be the service failing to start due to a login \ password error. Have you checked event viewer? If its a service issue the error will...
October 21, 2013 at 9:22 am
I thought I would post an update on this, the company were indeed a shambles. Surprisingly I scored 93% on the worlds most bizzare SQL test. They...
October 18, 2013 at 4:19 am
Its been a while since I used express, but management studio is available as a standalone download for express edition.
http://www.microsoft.com/en-us/download/details.aspx?id=7593
October 17, 2013 at 9:21 am
Viewing 15 posts - 301 through 315 (of 486 total)