Viewing 15 posts - 2,086 through 2,100 (of 9,253 total)
can you provide the full report?
Was this database previously a sql server 2000 database at any time?
May 27, 2015 at 6:54 am
vsuresh (5/27/2015)
After the upgrade can I switch the secondary database back to stand by read only mode?
Only if you upgrade the sql version on the primary too
May 27, 2015 at 6:20 am
how long has the db been sitting there restoring, if you're unsure initiate a fresh copy of the primary database and replace the secondary
May 27, 2015 at 6:19 am
vsuresh (5/26/2015)
Our production server and test server are currently on 2005. We have log shipping in place from production to test server. We are planning to upgrade to 2008 R2....
May 27, 2015 at 5:29 am
a master key already exists, so you don't need to create another. Just create the cert in the master database.
What is it you are attempting to do, are you trying...
May 27, 2015 at 5:17 am
first you'll need to check that the secondary has been restored to the appropriate point in time then join it to the availability group
May 27, 2015 at 5:16 am
yes, you can script the alter database commands quite easily using the system catalog sys.master_files 😉
May 27, 2015 at 5:15 am
What's wrong with just using sp_detach_db and create database for attach?
If all you're doing here is detaching to move files then this is totally unnecessary anyway and is an old...
May 27, 2015 at 1:51 am
or without the join
select db_name(database_id), name, physical_name
from sys.master_files
May 26, 2015 at 1:19 pm
William Soranno (5/26/2015)
May 26, 2015 at 1:16 pm
this demand is usually because they do not understand exactly what permissions are required or cant be bothered to maintain granular security, it's not an excuse
May 26, 2015 at 1:11 pm
If you install the clustered instance as evaluation edition and then wish to upgrade there will be an issue. This link details the upgrade paths from evaluation to
SQL...
May 26, 2015 at 6:30 am
SQL-DBA-01 (5/22/2015)
I found that some1 accidentally did nt mention d expiry date against each certificate so by default it took 1 yr of expiry.
Is there anyway I can...
May 22, 2015 at 8:59 am
Arestas (5/21/2015)
The architecture i am trying to implement is as follows:
3 Servers. 2 in primary site and 1 in a secondary...
May 22, 2015 at 8:52 am
feersum_endjinn (5/21/2015)
No, the cluster nodes are (rather will be) located in the same data centre, same room, same VM hosts.
Ok, got it
feersum_endjinn (5/21/2015)
May 22, 2015 at 8:40 am
Viewing 15 posts - 2,086 through 2,100 (of 9,253 total)