Viewing 15 posts - 3,121 through 3,135 (of 9,241 total)
GrassHopper (7/30/2014)
what is the sql server service acct (default)?
Whatever you set it to!!
Open sql server configuration manager on the server and check the acct in use for the sql and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:27 am
SQLSteve (7/30/2014)
I have 2, 2 node clusters
PROD1(cluster 1) Clustered SQL instance1
PROD2(cluster 1)
DR 1 (cluster 2) Clustered SQL insatace 2
DR 2 (cluster 2)
I have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 8:10 am
No, it wont. It allows acces to a range of system catalogs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 7:04 am
JeepHound (7/29/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 3:55 am
JarJar (7/30/2014)
??? how to setup ???
This link details the following
Technet: How to enable log shipping (TSQL)
2.On the primary server, execute sp_add_log_shipping_primary_database to add a primary database. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 3:11 am
See this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2014 at 1:33 am
wouldnt hurt to try it with the databases read only, good luck
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 10:18 am
sqldriver (7/29/2014)
Hello,Has anyone ever done a live physical to virtual conversion?
Yes, more than i care to remember :crazy:
sqldriver (7/29/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 9:27 am
if you're looking in explorer on the node where the disk is not online you won't see it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 6:25 am
Marios Philippopoulos (7/29/2014)
You need to:(1) Evict the standalone node from the WSFC cluster
(2) Install the sql on that node
(3) Add the node back to the cluster.
Be very careful here, when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2014 at 6:17 am
Chowdary's (7/28/2014)
I executed the Script against the DB , i got the following
SpaceUsedMbs, SizeMBs, GrowthAllowed, MaxGrowthSize,Growth and FreeMBs result.But from this result ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2014 at 7:45 am
all replys here http://www.sqlservercentral.com/Forums/Topic1596764-1550-1.aspx#bm1596804
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2014 at 6:31 am
Chowdary's (7/28/2014)
On 24th my Mdf size was 10GB,when i checked now the Mdf size was increased suddenly to 30GB.
First ascertain whether the file has free space or filled with data.
If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2014 at 6:26 am
Paul Morris-1011726 (7/25/2014)
Very cool, I will do this off hours just because i am paranoid. Let you know how it goes. Thanks for the help!
no need to be paranoid, just...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2014 at 9:52 am
Once you restored the database as a new name i would also then change the logical filenames as shown below (and based on my example)
ALTER DATABASE [bob] MODIFY FILE (NAME...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 25, 2014 at 7:16 am
Viewing 15 posts - 3,121 through 3,135 (of 9,241 total)