Can someone tell me how to increase tablespaces in SQL Server?
Is the syntax the same as Oracle? Is there a wizard in Enterprise Manager?
CheersThere is no concept of tablespaces in sql server...
well ok, if you consider creating separate file structures...then that would be close...
what are you trying to do?|||hiya
Yeh, I figured that (as in oracle you can increase the size of the tables),
The disk is 99% full (DB) and we are installing a new disk. We would like data to be written to the new disk (this is a temporary measurement until we upgrade the server) How do we set Map the data across?
Cheers|||Dump and Restore?|||The data for database files is written in parallel, while for log files sequencially.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment