Viewing 15 posts - 5,986 through 6,000 (of 9,244 total)
deva_etc (10/19/2011)
Also in SQL 2005, you have to perform the patch installation from the active node. In SQL 2008, you can patch from any node (rolling upgrade)
Starting 2005 SP2 there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 9:40 am
LutzM (2/14/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 9:05 am
Muralijv 51742 (2/14/2012)
I will try to restore the logs 4 times a day.Cheers
Murali
In that case log shipping would be perfect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 15, 2012 at 8:59 am
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
Viewing 15 posts - 5,986 through 6,000 (of 9,244 total)