CREATE WRITEFILE statement
484
CREATE WRITEFILE statement
Use this statement to create a write file for a database.
CREATE WRITEFILE
write-file-name
… FOR DATABASE
db-file-name
… [ LOG OFF | LOG ON [
log-file-name
[ MIRROR
mirror-file-name
] ] ]
write-file-name
|
db-file-name
|
log-file-name
|
mirror-file-name
:
string
The permissions required to execute this statement are set on the server
command line, using the
-gu command-line option. The default setting is to
require DBA authority.
The account under which the server is running must have write permissions
on the directories where files are created.
Not supported on Windows CE.
An operating system file is created.
"CREATE DATABASE statement" on page 427
"The Write File utility" on page 151
"Working with write files" on page 792 of the book ASA User’s Guide
Creates a database write file with the supplied name and attributes.
The file names (write-file-name, db-file-name, log-file-name, mirror-file-
name) are strings containing operating system file names.
$ For information on strings, see "Strings" on page 224.
If you specify no path, or a relative path, the file is created relative to the
current working directory of the server.
You cannot create a write file for a database that is currently loaded.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
♦ The following statement creates a write file..
CREATE WRITEFILE ’c:\\sybase\\my_db.wrt’
FOR DATABASE ’c:\\sybase\\my_db.db’
LOG ON ’e:\\logdrive\\my_db.log’
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
Example
To Next Page
Loading...