Information générale
Forum:
Microsoft SQL Server
Titre:
Create database and modify existing transaction log
Versions des environnements
SQL Server:
SQL Server 2000
Hi,
we create after installation of our application, if USE HM fails, with the following t-sql statement a database:
create database HM
We don't want give the File option FILENAME='c:\...', because we don't want to set absolute paths on SQL-Server machine (rights, ...).
We need commands for
- setting maxsize of transaction log from a unlimited size to a limited size
?ALTER DATABASE HM MODIFY FILE (NAME = N'HM_log ', MAXSIZE = 10)
- reducing (or deleting) size of transaction log, because maxsize can't
be reduced to a mb size lower than the actual size.
What is a recommended size for transaction log ?
Thank you,
Andreas
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement