Solved

OLAP database determining database file size and log size

Posted on 2013-06-18
1
323 Views
Last Modified: 2013-07-06
Experts,

I want to create a OLAP database that is going to be out about 50 gig in size(initially). How do I go about setting the database file size and the database log size?

Kind Regards,
Jedi
0
Comment
Question by:J3D1-KN1G1-1t
1 Comment
 
LVL 15

Accepted Solution

by:
jorge_toriz earned 500 total points
ID: 39257966
Ups, I didn't see the "OLAP" word, sorry pal, I posted a code but that was totally wrong
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question