Viewing 15 posts - 4,396 through 4,410 (of 9,244 total)
That's the order i prefer to do it in. Set the paths and confirm that sql server has updated the system catalogs, you will receive a meesage indicating that the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:44 am
Well, if you really can't wait for my guide to be published perform the following;
get details of the current paths\filenames using this query
select name, physical_name from sys.master_files where database_id =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:24 am
Ratheesh.K.Nair (1/17/2013)
I tried moving one of our user DB using
1.mode database offline..moved files run alter database modify files and made database online..it didnt took old .ldf file instead...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 3:08 am
AnzioBake (1/17/2013)
okay, so maybe my understanding is incorrectas examples:
Fixed server: 4 sockets, 8 memory slots, dual NIC, dual IO connectors
Blade: Four server slots, each with above
Invalid comparison, a blade server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2013 at 2:14 am
AnzioBake (1/16/2013)
Fixed servers have limitation too.
Such as?
Don't tell me that a machine such as an HP DL585 has disadvantages over a "pizza box" blade server!
[Quote]AnzioBake (1/16/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2013 at 11:42 pm
Blades are a neat way to shove a load of servers together in one manageable place. However, they have limitations and shared topologies.
IMHO, if you're SQL server is mission...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2013 at 5:04 am
ryan.offord (1/4/2013)
As far as I understand it I can have up to 16 nodes in a WSFC cluster.
Correct!
ryan.offord (1/4/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2013 at 4:44 am
As Joie has stated and as Paul Randal's article explains even with safety on (synchronous mode), without a witness a mirror disconnection will allow the principal to stay online and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2013 at 4:20 am
Do you absolutely require the secondary database to be restored that regularly, have you thought of deferring the copy and\or the restore jobs to run at low usage periods. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2013 at 8:45 am
Is the database in restore mode or Standby\readonly?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2013 at 7:36 am
runal_jagtap (1/10/2013)
yup i was talking abt LDF Files.
Yup???
You've been listening to Gail and Paul too much 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2013 at 7:34 am
no, the agent failure will not fail over the instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2013 at 7:30 am
DBA in Unit 7 (1/8/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2013 at 1:45 am
peterjbassi (1/8/2013)
Thanks Perry.That script worked was perfect.
You're welcome, there are other scripts around but they don't account for partitions and the new allocation units used by SQL Server 2005 onwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 8:00 am
Innerise (1/8/2013)
Suppose we have a production SQL cluster, 2 nodes, active/passive.Also suppose we also have a DR cluster SQL cluster, 2 nodes, active/passive.
I can understand the provision of high availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2013 at 7:03 am
Viewing 15 posts - 4,396 through 4,410 (of 9,244 total)