You are hereSQL Server
SQL Server
Moving large table to another file group
I have a large errorlog table in my database, with 2M records and 1GB data. I'd like to create a standalone file group for the error log. I tried to use management studio to modify the table, but it's timeout. So I have to do it manually. I'm sure there's better way to do this, but here's my note which works:
Install PDO, PDO_SQLITE, PDO_DBLIB, PDO_MYSQL
Recently I'm using PRADO framework for some web application development. It comes to deploy to the server side.
The server is running Debian 3.1r3
pear/PDO_DBLIB requires PHP extension "pdo" (version >= 1.0)
No valid packages found
install failed
The server is running Debian 3.1r3
- apt-get install php5-dev php5-mysql php5-sybase php5-sqlite libmysqlclient-dev freetds-dev
- apt-get install make
- pecl install PDO
- pecl install PDO_SQLITE
- pecl install PDO_MYSQL
- pecl install PDO_DBLIB
pear/PDO_DBLIB requires PHP extension "pdo" (version >= 1.0)
No valid packages found
install failed



