Viewing 15 posts - 4,006 through 4,020 (of 9,253 total)
When you specify the EMPTYFILE clause to DBCC SHRINKFILE the database engine stops writing new data into the file and all existing data is moved out.
July 30, 2013 at 6:50 am
be careful about just copying system databases between instances, especially clustered instances. Things like different computernames or collations and SMKs can cause a lot of trouble. Migrate the objects between...
July 30, 2013 at 6:48 am
The full install media automatically detects your architecture platform and launches the appropriate installer.
July 29, 2013 at 11:57 pm
Even using a partitioning tool on an online cluster volume, i'm not sure this would be a wise thing to do, i assume this is what you are using.
IMHO,...
July 29, 2013 at 8:29 am
starting SQL Server 2008 there is an option available when using the -m parameter which sets the app name that is allowed to connect in single user mode.
This limits connections...
July 29, 2013 at 4:41 am
the install media has install locations for x64, x86 and itanium.
July 29, 2013 at 4:34 am
sql-lover (7/25/2013)
I want to shrink an existing LUN that holds tempdb and I want to do it on the fly, without taking the SQL failover instance down.
Not going to possible,...
July 26, 2013 at 6:43 am
balasaukri (7/25/2013)
We were trying to expand SAN disk size more than 2 TB as part our requirment. But it failed due to the limitation, NTFS can support maximum of 2...
July 26, 2013 at 6:30 am
please provide full schedule details of any scheduled backups that occur so that a restore path may be suggested
July 26, 2013 at 6:18 am
Elliott Whitlow (7/25/2013)[hrI generally suggest you add ALL SQL instance to all nodes.
I wouldn't advise this, in fact the SQL Server installation documentation directs you to install the clustered...
July 26, 2013 at 1:53 am
Steveyam90 (7/25/2013)
Otherwise you are stuck 🙂
not necessarily, see my solution above.
July 25, 2013 at 12:04 pm
shrinking is not as easy as extending a volume, from what i have read it seems that you want to convert to using mounted volumes is that correct?
July 25, 2013 at 2:39 am
unless the backup was created as a self extracting archive its not going to be possible without
Depending on the version of...
July 19, 2013 at 7:11 am
saqlainkhan (7/16/2013)
They want you to break mirroring while they move the storage?
YES
What are they moving, just the mirror instances storage or the principal too?
THEY ARE MOVING JUST...
July 19, 2013 at 5:51 am
Viewing 15 posts - 4,006 through 4,020 (of 9,253 total)