Viewing 15 posts - 4,486 through 4,500 (of 9,241 total)
they both achieve the same result. Detaching removes the database from the system catalogs whereas offline doesn't.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 10:03 am
Jeff Kelly-310227 (12/5/2012)
We understand that typically multiple files are used to spread out the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 9:23 am
Bhuvnesh (12/5/2012)
with 0 or 100 fillfactor ..more space is required and IO also get affected)
You cannot specify a fillfactor of 0 in the rebuild command, any attempt to do so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 7:02 am
craig.dixon (12/5/2012)
Thanks for the reply 🙂 When taking the backups, in the overwrite media section, I have selected to "Back up to the existing media set" and the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 4:42 am
Mh-397891 (12/5/2012)
1. Remove the SQL 2008R2 from Cluster1\Node1
You don't need to retain any databases from here then??
Mh-397891 (12/5/2012)
2. Install SQL 2012 in Cluster1\Node1 along with SP1
Why when you already have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 4:38 am
If the principal is down and you want to bring the mirror up you will need to force service using
ALTER DATABASE mydb SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:56 am
you'll need to offline the SQL Server clustered service resource, then add the dependency, the bring the resource online.
Ensure you add the stoarge to all required cluster nodes and add...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:51 am
SQL Server browser is used to locate named instances of SQL Server on the host. Are you using any named instances on the server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:11 am
SQL Server 2005 Std to SQL Server 2012 Ent is a valid upgrade path, what is the service pack level of the SQL Server 2005 instance?
This needs to be service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:09 am
you can upgrade from SQL Server 2005 Ent edition directly to SQL Server 2012 Ent edition, but the SQL Server 2005 instance will need to be at service pack 4.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:06 am
Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows
ALTER DATABASE mydb SET OFFLINE
Once offline,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:04 am
Mh-397891 (12/4/2012)
And we have another cluster Cluster2 which is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 2:00 am
They read the MS kb did they 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 2:19 pm
Ok but generally you would want at least 2 or 3 NICs teamed for your public connection to provide redundancy.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 11:50 am
Have you used network teaming before??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 8:48 am
Viewing 15 posts - 4,486 through 4,500 (of 9,241 total)