Viewing 15 posts - 3,511 through 3,525 (of 9,253 total)
Rem70Rem (2/28/2014)
What is the best way to move a Production database to a test one ever days after processing is done ?
I am thinking about backup/restore as...
March 3, 2014 at 4:59 am
eligiable (3/2/2014)
I'm trying to update the following table (SQL Server 2008 R2):
MerchantNoTerminalNoCounterNo
7000001370000014NULL
7000001370000015NULL
7000001370000016NULL
7000001370000013NULL
7000003270000032NULL
7000003270000031NULL
I need the CounterNo to be updated as following, against TerminalNo:
MerchantNoTerminalNoCounterNo
7000001370000014Counter 4
7000001370000015Counter 3
7000001370000016Counter 2
7000001370000013Counter 1
7000003270000032Counter 2
7000003270000031Counter 1
I'm trying...
March 2, 2014 at 7:45 am
you don't seem to be making any account for mounted volumes in your script, you must try to move away from legacy system catalogs and look at the new catalogs...
February 28, 2014 at 2:50 am
Marios Philippopoulos (2/27/2014)
Perry Whittle (2/27/2014)
Marios Philippopoulos (2/26/2014)
When first installing the FCI, we first installed...
February 27, 2014 at 9:04 am
Marios Philippopoulos (2/26/2014)
When first installing the FCI, we first installed it on A and...
February 27, 2014 at 3:50 am
seandakid (2/26/2014)
I am wondering if anyone has any documentation confirming this...
February 27, 2014 at 3:38 am
In the connect dialog the instance name should be
Computername\SQLEXPRESS
February 26, 2014 at 1:28 pm
robin.pryor (2/26/2014)
February 26, 2014 at 9:27 am
SQL-DBA-01 (2/25/2014)
Hi,How to find when (date/time) a database was last removed from AlwaysOn Listener?
Is there any query (DMV) to find the details easily?
AlwaysOn databases are bound to an AlwaysOn group,...
February 26, 2014 at 2:24 am
quackhandle1975 (2/25/2014)
then restore a full bk from source instance and run all the checks at that point
That is another way. Typically time it so the database is migrated fairly soon...
February 25, 2014 at 11:06 am
grantbanjo (2/24/2014)
I first ran a search for on the Internet and then on SQL Server Central for this situation, but was unable to find a close match.
I have SQL Server...
February 25, 2014 at 2:51 am
When you attach\restore the 2005 database to 2008 the database will go through an internal SQL Server upgrade, this does complete a fair amount of logical checks. Get the database...
February 25, 2014 at 2:45 am
check the cluster events for any errors. Have you perfomed a cluster validation after adding the new node to the Windows cluster but before attempting to run the SQL Server...
February 25, 2014 at 2:42 am
Have you checked the restore job step history closely. The step may indicate restore issues but still marks as successful.
February 25, 2014 at 2:39 am
Viewing 15 posts - 3,511 through 3,525 (of 9,253 total)