Viewing 15 posts - 4,486 through 4,500 (of 9,244 total)
jmaikido (12/5/2012)
I have the exact same requirement whereby I have been given the task to LS multiple databases. approx. 25 @ this stage. (SQL2008R2) As I'm not one for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 11:41 pm
F. Dwarf (12/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 12:18 pm
sqlfriends (12/5/2012)
Thanks, but it seems detach and attach is easier and involves less steps to do.
Do whatever you feel comfortable with, just know that in SQL server 2005 on ALTER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2012 at 12:16 pm
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
Viewing 15 posts - 4,486 through 4,500 (of 9,244 total)