Alters an existing store.

Syntax

---

ALTER STORE <StoreName> AS <LocalStoreDefinition>|<RemoteStoreDefinition>
[DESCRIPTION <Description>]
[ATTRIBUTES <CustomAttributes>]

<LocalStoreDefinition> =

LOCAL PATH <Path>

<Path> = Any valid operating system path

<RemoteStoreDefinition> =

REMOTE ADDRESS <IPAddress>|HOST <Host>
PORT <Port>|SERVICE <Service>
USER <UserName>
PASSWORD <Password>
STORE <RemoteStoreName>
[SIGNATURE <Signature>]
[ENCRYPTED]
[ENCRYPTION PASSWORD <EncryptionPassword>]
[COMPRESSION <Compression>]
[TIMEOUT <Timeout (seconds)>]
[PING <PingInterval (seconds)>]

<Compression> = 0..9

Usage

---

Use this statement to alter an existing store.


Examples

---

-- The following statement alters a local Backups
-- store to use a new path.

ALTER STORE "Backups" AS
LOCAL PATH 'c:\backups'
DESCRIPTION 'Support Database Backups'

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: