Hi all. I have a client who is still on MS SQL Server 6.5. They have run out of room on their server and want to increase the size of their existing DB. Is there a way to create a device on another server? I tried mapping drives but that didn't work.

Create a secondary file group and point it to your new drive
Here is a sample from Books Online
USE master
GO
ALTER DATABASE Test1
ADD FILEGROUP Test1FG1
GO

ALTER DATABASE Test1
ADD FILE
( NAME = test1dat3,
  FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat3.ndf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB),
( NAME = test1dat4,
  FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat4.ndf',
  SIZE = 5MB,
  MAXSIZE = 100MB,
  FILEGROWTH = 5MB)
TO FILEGROUP Test1FG1

ALTER DATABASE Test1
MODIFY FILEGROUP Test1FG1 DEFAULT
GO


Jaime E. Maccou
Applications Analyst

Can this be done with a mapped drive (i.e. z:\data\moredata.dat)

where

z is mapped to \\some_server_somewhere\sql\data

is this possible?

Mapped Drive? No, SQL recognizes the physical drive


Jaime E. Maccou
Applications Analyst