Thursday, March 7, 2013

[MS SQL Server] #Files and FILEGROUPS

[MS SQL Server] #Files and FILEGROUPS


#Files and FILEGROUPS

Posted: 06 Mar 2013 07:49 PM PST

Hi,In an 8 CORE machine with 3 RAID10 (data files, log files and tempdb) what's the appropriate number of files or filegroups for a database with lots of users and IO? I saw a SQLPass presentation where it said 1 file for 4 CORES..If a database has 2 files and since the files are on the same RAID set is it worth creating also 2 FILEGROUPS (one for each data file) or the porpoise of FILEGROUPS is to put "sensible" data on one and not so sensible data on another so the 1st one has backups more frequently?Thanks,Pedro

Starting up in Single user mode

Posted: 19 Jan 2010 01:15 AM PST

I am testing a disaster recovery process but am unable to restart any 2008 systems in single user mode so that I can restore the master db. The sql server instance is stopped when I issue the command. I have tried this on three systems so far with no luck please help.D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn>sqlservr.exe -m2010-01-19 11:09:35.82 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:35.82 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:36.12 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:36.12 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:36.42 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:36.42 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:36.72 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:36.72 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:37.03 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:37.03 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:37.33 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:37.33 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:37.63 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:37.63 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:37.93 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:37.93 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:38.24 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:38.24 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).2010-01-19 11:09:38.54 Server Error: 17058, Severity: 16, State: 1.2010-01-19 11:09:38.54 Server initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

Install SQL server from command line and configuration files

Posted: 07 Mar 2013 05:07 AM PST

I would like to try use command line and configutionfile to install SQL server.I read I should put the commandline fine in the root of installation file.We have a shared folder that has all the installation file on the network, I don't have write permission on that folder. I don't want to copy those installation files to my local too, then what other options can I do?I tried to add in the command line to change the directory to the installation files location at start, but since it is a shared directory, I got an error: CMD does not support UNC paths as current directories.Any recommendations?Thanks

build a small sql server

Posted: 07 Mar 2013 01:38 AM PST

Hello,I am trying to build a sql server. It can probably be good enough for a small business and run on MS SQL Server 2008 R2. Can anyone recommend me with the brands, processors, motherboards, etc...? Maybe cost $1,000 less would be better.Thanks,

Duties of a DBA

Posted: 06 Mar 2013 04:51 AM PST

Could someone please brief me about the daily duties of a production support SQL Server DBA?

Data Archival/Purging - through table partition switch IN/OUT

Posted: 06 Mar 2013 03:49 PM PST

Hi All,I have a daily partitioned table 'TBL' and I hold data for 30 Day's. I archive data to TBLHistory table by Switch out minimum partion and switch in the partition to TBLHistory.The Main Table 'TBL' and 'TBLHistory' resides on the same database. As a result size of database is increasing.My manager ask me to Create a HistoryDB database and move 'TBLHistory' to the history database.Can i move 'TBLHistory' to HistoryDB and still i can perform switch out and Switch in?Note:Both DBs are residing on same instance of the server.(MainDB) -->TBL-->SwithOut to --> Swith In to --> (HistoryDB)-->TBLHistory ?Please guide me how can i best achive this.Thanks Vineet Dubey

No comments:

Post a Comment

Search This Blog