Viewing 15 posts - 7,936 through 7,950 (of 9,241 total)
Alex Webber (5/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 7:32 am
before removing any files check their contents. Can you post the results of the following queries?
USE yourdb
select name from sys.filegroups
USE yourdb
select a.name as 'Index name', b.name as 'Filegroup',
c.name as 'Table...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 2:05 am
check this link for more info
the following info is relevant
A log backup is required to move the head of the log forward (full or bulk-logged recovery models only).
Note:
Log backups...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:49 am
shew (5/20/2010)
We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:29 am
In most cases Standard edition is suitable for what most people require. Unless you plan to have multi node clusters, require IA64 support, get heavily into partitioning, require compression and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:14 am
TRUNCATE requires ALTER permission on the table which you will also need for adding the constraint. You will probably also require ALTER on the schema too!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:08 am
no its nothing like Office. Pick your self up a copy of the SQL Server 2008 training kit you can get it reasonably priced from Amazon, this is your best...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 12:53 am
hamidi 97216 (5/11/2010)
since i didn't know which ones to select, i selected all of the features.
OK this slightly worries me. How can you expect a stable installation if you do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2010 at 10:03 am
Franco
transferring logins to SQL Server 2008 uses the same script that you have for 7\2000 to 2005
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2010 at 6:11 am
Scott Hedrick-378512 (5/19/2010)
Perry, what don't you like about DPM backups of SQL Server? We are considering using it and would appreciate some real world feedback. Thanks.
Hi Scott
i didnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2010 at 11:06 am
Oracle_91 (5/17/2010)
Thanks Perry!Those are too good.:-)
Thank you, glad they are able to help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2010 at 10:30 am
hamidi 97216 (5/11/2010)
where is it located?
on the failure notification it gives you the log location?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2010 at 10:29 am
honestly i cannot any of this would generally be an issue. I do not enable CDOC, as the KB says you must be fully aware of the security implications. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2010 at 1:55 pm
Hi
welcome to Windows clustering. Which version of Windows clustering are you planning to use 2003 or 2008. Just for clarification what version of SQL Server do you plan to use,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 16, 2010 at 1:14 pm
Hi
try installing the following file first then re run setup
'E:\Software_Installations\SQLServer_2008\x64\setup\sqlsupport.msi
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 15, 2010 at 2:01 pm
Viewing 15 posts - 7,936 through 7,950 (of 9,241 total)