How to create a database with files (mdf & ldf)? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to create a database with files (mdf & ldf)?

Hello,
Can anyone plz send me the relevant code to create a database with files (data files & log files) & with the filegroup.We need to create 2 data files & those two data files will be in two different filegroups.Same create two log files & those two would have to be in two diff file groups .
then take the backup of the filegroups individually. It’s a long process.
Can any1 plz help me by giving the code. Thanks & Regards Sourav M.
You can read CREATE DATABASE in books on line. You will find all what you need.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
]]>