.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

why only one file is grew two times by 10 % after all files are filld

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
hi, i have one data file group DATA,With 8 files associated with this.... two files in each four disk drive. i am setting the initial size of each file 1mb and auto grow by 10 % unrestricted. till 75 gb it works fine data in all the files are evenly distributed but once it reaches to 75 GB only one of those files is increasing two times rest of the files remains same... like (75*1.1)*1.1 others are 75 GB.. i expect it should increase first file by 10 % fill it and then pick second file expand by 10 % and fill and so on..  what could be the reason?? can any one help me on this??/

View Complete Post

More Related Resource Links

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Code Name WinFS: Revolutionary File Storage System Lets Users Search and Manage Files Based on Conte


One of the monumental problems organizations face today is aggregating information that's stored in disparate formats. Knowledge workers have long wanted to be able to search for content independent of format. The next version of the Windows operating system, code-named "Longhorn," boasts a new storage subsystem that makes that task easier. That subsystem, code-named "WinFS," allows the user to perform searches based on the metadata of the stored item, regardless of what type of file it is or which application created it. This article covers the basic architecture of WinFS and explains how to use the WinFS managed API.

Richard Grimes

MSDN Magazine January 2004

Reg File Upload control to upload files from document library


In Field Upload control if we click browse button it allow us to search file in our hard disk but now as per my requirement as soon as user clicks ‘Browse’ button it should point to the document libraries and their files in site.Let me know how could i achieve this?

Thanks & Regards,


Changing File Permissions of Disconnected MDF/LDF Files

I am a university professor and have over a hundred student project databases using the developer edition of SQL 2005 and 2008 on a portable hard drive.  All are disconnected from any server.  I need to move these to a new hard drive but no file system tool I can find will let me copy the .mdf or .ldf files.  Each of these files has a single user with permissions and the user is a long alpha/numeric string that seems to have been generated by SQL.  I can copy these files if I select each file individually and give full control permissions to my current login.  On some files I need to first take ownership.  I just don't want to have to go in and do this manually for 200+ files scattered all over the drive. I really need some sort of batch approach (including something that can be launched from within VB which I can use to navigate my drive's folder structure looking for .mdf/.ldf files) to let me change the permissions on these files.  As I said, I have a LOT of them and they are scattered around a deep folder structure organized by semester, course, project team, and sometimes project version.  Further, the files accompany other files such as VB projects, report projects, SSIS projects, etc.  I have access to Windows Vista and Windows 7 for doing this.

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.

RBS Maintainer not cleanup files in file system (SharePoint 2010)

Here's my environment:   Server #1: SQL Server 2008 R2 Express, RBS enabled Server #2: SharePoint Foundation 2010, RBS installed I setup RBS according to this http://technet.microsoft.com/en-us/library/ee663474.aspx successfully. And I can see the files are storing in NTFS file system instead of database. And then I'm configuring RBS Maintainer according to http://technet.microsoft.com/en-us/library/ff943566.aspx . But it doesn't seem working as expected. I deleted the file from SharePoint Document Library and emptied recycle bin, even in site collection recycle bin. And even I delete the whole site collection. The RBS Maintainer doesn't delete the files in file system. I've updated the following rbs config on my content database for test: exec mssqlrbs.rbs_sp_set_config_value 'garbage_collection_time_window', 'time 00:00:00'; exec mssqlrbs.rbs_sp_set_config_value 'delete_scan_period ', 'time 00:00:00'; exec mssqlrbs.rbs_sp_set_config_value 'orphan_scan_period', 'time 00:00:00'; Maintainer output after I deleted the file, emptied end user recycle bin and site collection recycle bin : C:\Program Files\Microsoft SQL Remote Blob Storage 10.50\Maintainer>"C:\Program Files\Microsoft SQL Remote Blob Storage 10.50\Maintainer\Microsoft.Data.SqlRemot eBlobs.Maintainer.exe" -Connect

How to merge sheets from multiple excel files into one .xls file?


 I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.

 How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?

 Thanks in advance.

Setup file(*.msi) also includes .aspx.cs (source code) files also


My project is recently migrated from 2008 to 2010

actualy we developed project in VS 2005 in that we created setup file but when we migrated to vs2008 setup file giving problem to us.

now when we make setup file it is including .aspx.cs files also but this if we publish our project it wont including source code.

why setup file including .aspx.cs files is there any way to change.

plz replay ASAP

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.


Hello everybody.

I am in a critical situation. I first tried to make a project (file->new->project) using visual studio, where I displayed the content of a excel file by GridView. I was successful then, but when I attach it to my website located in inetpub I am getting this error :

Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\ProjectWebSite\Files\ROUTINE_MCA.xlsx'. There are several possible reasons:

. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.

At first I faced some COM related problem and found solution in Google, but this particular problem is not solving. Is there any way to access Excel document in asp.net website?

In my application there is a facility of uploading excel document to the server and then display its content. But I have failed to do this display operation, is there any turn around way, like store the excel document as dataset and then access it as required.

Please help. I am in great trouble. Thanks in advance.

Link to css file is two times in web page, css is not working



When I am building and running a webform, the link to a css file is two times in the head.
And the css is not working, can any one help me please.
The code is:

In the view source of the webpage:

   Home - MKB Databasebeheer
</titel><link href="App_Themes/MKB/MKB.css" rel="stylesheet" type=""text/css" /><link
hred="App_Themes/MKB/MKB.css" type="text/css" rel="stylesheet" /><style type="text">

The code in the master page is:

 <head runat="server">
  <title>Mkb Databasebeheer</title>
  <link href="App_Themes/MKB/Mkb.css" rel="stylesheet" type="text/css" />

The code in web.config is:

<page theme="MKB" masterPageFile="~/MKBDatabasebeheer.master: maintainScrollPositionOnPostBack="true" />

I hope that it is clear to you what I have done, and what I have done wrong?



When dynamically creating an excel file, can SSIS create xlsx files successfully? I can only get SSI


Problem: An Excel file (XLSX) dynamically created by a SQL Task cannot be opened via Excel. The task succeeds, but when you try to open the workbook in Excel you get the fillowing error message: Excel cannot open the file 'myfile.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

1. If the Excel file (xlsx) is created manually in Excel, then the SQL Task has no problem creating table (new worksheets) in the xlsx (so the "CREATE TABLE" statement works fine)
2. If I adjust the connection and task to work with Excel 97-2003 (xls) format then the approach works perfectly
3. The execution results show success of the SQL Task, but there are two warning messages. These same warnings appear when the SQL Task creates a new table (worksheet) successfully in a workbook (xlsx) which was created manually in Excel (and is not corrupt). Messages as follows:
Warning: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Warning: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

SSIS Details:
1. ConnectionString: "Data Sour

SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





How to get a mdf file back from sql files recovered from SQL Recovery Toolbox?



I had a corrupted mdf file so I purchsed SQL Recovery Toolbox to fix it. When it repaired the file, it spat out a number of sql files and an install.bat file. Because the file was a sql 2008 express file, i'm supposed to now use sqlcmd.exe to fix it. Apparently to get it back to a mdf file, I need to create a blank database and somehow use sqlcmd.exe to import the sql files into the new mdf file.

I use a security program which installs sql express 2008 during the install. I don't know how to use MS Sql. The security program I use has it's own batch file to attach or detatch the two mdf and ldf file to it. I emailed the SQL Recovery Toolbox tech support for instructions on how to created a new mdf db and import the repaired sql files but they basically said that they have an agreement with MS and cannot tell me how to do it.

Can someone please let me know what to do or where to look for assistance? I am stuck at the moment and don't know what else to do.

Any help greatly appreciated, cheers.  

File.Copy to Program Files Directory.

I searched high and low and have found some discussions on this topic but do seem to see any solutions.   So here is my issue.   I have an application that will copy 2 files to the Program Files directory.   What happen is, when I run it and the files exist (this should be what normally happens) I get accessed denied.   If I try to do a File.Delete (in code) first I get an access denied, however I can manually (in OS windows explorer) delete the files and then the copy will work.   I am running the application as Admin, so permissions to the folder are good.  

The application is restoring a 3rd party software file that tends to get corrupted a lot.   We have mechanism that will back this file up, but when I try to restore it I get the problem described above.   (not a file lock issue, I have made sure no programs have a handle to the file)

OS = Vista32
Program written in C#

Is there anyway of accomplishing this?


Can't find "Recent files" in File menu SQL Management Studio 2008


After installing SSMS 2008 the menu item File->Recent files   disappeared. I tried to add this item via Tools-> Customize. Now I can see it in menu "File" but it still doesn't work. I click on it but there is no result. What should I do to fix this problem. It is very inconvenient to open files with File->Open->File.

copy files which are before a certain file


Hi Guys

How can I copy files which are before a certain file?
Eg.  file1 created at 10:10:00
        file2 created at 10:20:20
        file3 created at 11:11:11
        file4 created at 12:12:12
I want to copy files created before file3 which are (file1 and file2)
Using Batch programming

Problem with security on ISS?, why can i write HTML file but not XML files


hi guys

I have a web app the manages articles, users can generate articles which we store in the database and also in a folder inside the application in html.  We also have the ability to generate real time alerts, to targetted audiences but the list of audiences was cached from an sql query on the web server and at times, the cache was cleared by the server. so i wrote an http module, and the module now runs the query using a timer, and this then wrties the audiences to an xml file within a folder in the same application (same as my html files)

Now the weird thing is im getting the system.io unauthorised access exception, when i try to delete and overwrite the xml file.  Yet this doesnt happen when i write the html files.

Now although my users do login, there credentials are maintained via an sql database table, not windows security or the asp.net security model. 

Ive checked the folder that we publish our applications up to (its a mapped folder like a virtual directory), and i cannot see the network service or asp.net machine accounts usually used in iis5 or 6.  But i dont have the ability to change this anyway. 

Why would the html file write fine, and the xml file throw this error. 

I also changed my code to used HttpRuntime.AppDom

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend