[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Under Workstation 7, you can adjust the size of the virtual hard disk from the graphical interface:
Select the corresponding virtual machine in the list.
Click on Edit virtual machine settings.
Select the Hard Disk menu item.
Click on Utilities > Expand.
Enter the new size and press Expand.
Execute the steps according tot he VMware Knowledge Base , in order to adjust the guest operating system’s partitions to the new hard disk size.
ALTER DATABASE database_name SET OFFLINE;
Open in new window
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name, FILENAME = 'new_path\os_file_name' );
ALTER DATABASE database_name SET ONLINE;
SELECT name, physical_name AS CurrentLocation, state_desc
WHERE database_id = DB_ID(N'<database_name>');
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.