Viewing 15 posts - 136 through 150 (of 279 total)
Yes, run setup.exe from cmd
http://msdn.microsoft.com/en-us/library/ms144259%28v=sql.100%29.aspx
eg: Setup.exe /qs /Action=Install /Features=SQLEngine /InstanceName=NewInstanceName /SQLSYSADMINACCOUNTS="domain\sysadmin" /IAcceptSQLServerLicenseTerms
July 13, 2013 at 5:05 am
http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.100%29.aspx#DC_Support
Section: Installing SQL Server on a Domain Controller
The biggest issue is reinstalling SQLServer before promo and then after changing from DC to domain meber.
"After SQL Server is installed on a...
July 9, 2013 at 11:46 am
What have you checked?
Because this "112(error not found)" =There is not enough space on the disk.
http://www.mssqlforum.com/threads/a-list-of-operating-system-errors.26/
July 9, 2013 at 3:43 am
S_Kumar_S (7/6/2013)
HI...Do I always need to do a full database restore of ServerA with NORECOVERY and then Apply differential with RECOVERY?
Yes.
http://msdn.microsoft.com/en-us/library/ms175526.aspx
"A differential backup is based on the most recent,...
July 6, 2013 at 2:28 pm
http://en.wikipedia.org/wiki/Merge_%28SQL%29
"Microsoft SQL extends with supporting guards and also with supporting Left Join via WHEN NOT MATCHED BY SOURCE clauses."
July 6, 2013 at 3:38 am
All license arrangement are not clear 😉
But
"To access a licensed SQL Server, each user or device must have a SQL Server CAL that is the same version or newer than...
July 4, 2013 at 1:02 pm
Explanation from MS how to license MSSQL CAL/Multiplexing etc.
July 4, 2013 at 8:40 am
Why
ALTER DATABASE DbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
....
this leaves one connection which block yours restore, try this
ALTER DATABASE DbName SET offline WITH ROLLBACK IMMEDIATE;
....
July 3, 2013 at 7:11 am
No. After shrink index rebuild process can take more time if there will be not enough free space in the DB file to rebuild index.
June 11, 2013 at 1:56 am
No, OFFLINE = offline.
"Table locks are applied for the duration of the index operation. An offline index operation that creates, rebuilds, or drops a clustered index, or rebuilds or drops...
June 4, 2013 at 12:42 am
chewychewy (6/3/2013)...
I supposed the above is when rebuilding online?
With the offline option, is it the same as above?
thanks
No, in both case space for a new copy of index is required.
ONLINE...
June 3, 2013 at 10:13 am
Divine Flame (6/3/2013)
e4d4 (6/3/2013)
And shrink the tempdb while in use can cause inconsistency error in tempdb http://support.microsoft.com/kb/307487
As per the URL given by you "This article discusses three methods that you...
June 3, 2013 at 9:47 am
And shrink the tempdb while in use can cause inconsistency error in tempdb http://support.microsoft.com/kb/307487
June 3, 2013 at 7:44 am
Db file: can grow to accomodate new index before dropping old one, so it need a free space of size the largest index that is rebuild.
DB log: this depend on...
June 3, 2013 at 6:41 am
Viewing 15 posts - 136 through 150 (of 279 total)