Viewing 15 posts - 5,986 through 6,000 (of 9,241 total)
Correct.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2012 at 2:54 pm
sqlfriends (2/13/2012)
Thanks, but I got Invalid object name 'sys.dm_server_service'.
What version is your SQL Server instance, the script above is only valid for SQL Server 2008 R2 SP1 onwards. Get your...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2012 at 2:54 pm
no, you can do it via SSMS too, on the files tab of the database properties.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2012 at 2:43 pm
what edition\version VMWare are you planning?
most of the common ESX licences only allow up to 4 way SMP for VMs.
2vCPUs and 8GB RAM should be enough i would have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2012 at 2:40 pm
sqlfriends (2/13/2012)
When I restore database by using SSMS, I see I can only change physical file name, I don't have a option to change logical name, is that correct?
Correct.
sqlfriends (2/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 13, 2012 at 2:32 pm
all partitions are using either a 1MB offset (Windows 2008 default) or 64K offset.
Only partition 1 on disk 1 has different alignment offset.
Now, can you post your calculations you used...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2012 at 10:24 am
sqlfriends (2/10/2012)
Will 2008 version SSIS package still work on R2 SSIS?Thanks
Depends on what the package is doing! If its a basic package with no special features then probably yes. You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2012 at 3:28 am
pause mirroring and change the service account(s).
Ensure you change the mirroring endpoint(s) security and resume mirroring.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 5:40 pm
Jeff Moden (2/10/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 4:54 pm
JC-3113 (2/10/2012)
another issue just cropped up with regards to database owners and need some advice
it seems that a majority of my databases were created by lets say Domain1\User1
User1 is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 10:47 am
David Benoit (2/10/2012)
I would have the following to be sure that I was able to catch what you want;SP:Completed
SP:StmtCompleted
SQL:BatchCompleted
SQL:BatchStarting
SQL:StmtCompleted
If capturing the objects in red above I would also capture...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 10:43 am
Jinu43 (2/10/2012)
I have same issue.Where did you forced the restore option or which changes you made on primary server??
Thanks in advance.. 🙂
If you're having the same issue experienced in this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 10:27 am
sqldba4u (2/10/2012)
Is there any way or t-sql to find database name with corresponding certificate name in sql server 2008? I am referring with respect to TDE mechanism.Thanks.
Here you go
USE [YourDB]
selectdb_name(dek.database_id)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 10:10 am
Yes, fail all instances to one node.
Go into VCS cluster console and for all cluster groups place them into Freeze-Temporary
Once this is done reboot all passive nodes and then run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2012 at 1:04 pm
kellithompson (2/7/2012)
Nevermind. I finally got it working. Because of the failover cluster, I want to use high safety w/o auto failover (synchronous), right?
Offhand i'm not entirely certain, what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2012 at 8:11 am
Viewing 15 posts - 5,986 through 6,000 (of 9,241 total)