Need Advice On Expanding To Direct Attached Storage
Jan 10, 2007
We are currently using an application which uses SQL Server 2005. Both sit on the same box.
This month we're adding another piece of software to our network on a new box which also depends on SQL Server. Since we don't have a directed attached storage device to store (as recommended by Microsoft), we're contemplating installing SQL Server again just for this application. Of course this means that we have to maintain two separate SQL Server databases.
How to implement distinct storage tiers on SQL Remote BLOB Storage (RBS)?
I want to use this SQL Feature to move files(images, videos, pdf files) from a database to a distinct database dedicated to RBS. Then I want to have several storage tiers, where objects will be saved and moved according access frequency. Old data will be arquived in cheap storage, but it must be always accessible if needed.
Description: - 1st and main tier: new and frequently accessed objects stored in high performance storage; - 2nd tier: automatically move older or less accessed objects to an inexpensive and different storage tier; - in all cases, all objects must be accessible to all users, but accessing to archived objects(2nd tier) will be much slower;
I am a Windows developer for the IBM Tivoli Storage Manager Server (TSMS) product. Our product installation is built with InstallShield and uses the Windows Installer.
On a new installation of Windows 2003 x64 Storage Server R2, at a customer's site, the TSMS product fails to install. The install of the OS has version 3.01.400.3959 of the Windows Installer and I see no newer version that installs.
Part of our product is 32 bit (console) and another part is x64 (server). When installing I can see that the install's default is being redirected/reset to C:Program Files (x86)TivoliTSM after it is explicitly set by a custom action to ..Program Files.. . I further observe that our custom actions to write 64 bit registry entries are being refused.
REGSAM samMask = KEY_ALL_ACCESS; if ( regIsWow64Process () ) samMask = samMask | KEY_WOW64_64KEY; lStatus = RegCreateKeyEx( hLocalConnectKeyRoot, szSubkey, 0L, NULL, REG_OPTION_NON_VOLATILE, samMask, NULL, hKey, &dw ) ; The above fails to create the key.
We have tried four versions of our TSMS spanning many changes but the install acts the same. This does not happen on any other Windows OS we test on but we do not test on Windows 2003 Storage Server R2 being that it is an OEM product. We did test on Windows server 2003 R2 x64 and do not see this problem.
Do you have any suggestions on how to tackle this problem? I have full installation traces but can only see that the registry work is being refused. I can't see why.
I was writing a view that required all of the fields from several large tables. Though I used the * operator in my SELECT statement, SQL Server automatically expanded it to show all of the columns every time I saved the view. Is there a setting somewhere that I can change to make it stop doing that? The query becomes extremely difficult to read because there are so many fields.
I want to expand a log device and am having a problem. When in Edit Database Device, the `Change Now` button is disabled and the size of the device is shown as a negative number.
I have a SQL 6.5 database that we parse some data into everyday usingan access program. All this was devises and setup by a programmer thatI can't get in contact with anymore and it has actually run for aboutfive years without a hickup! But just a few days ago our parsingprogram just stops dead before completing and I did get this errormessage."exportaLLdataToSQLifnoerror(): number 3146 Description- odbd- callfailed. [Micorsoft][odbc SQL Server Driver] [sql server] Can'tallocate space for object 'syslogs' in database 'newpdatasql' becausethe 'logsegment' segment is full. If you ran out of space in Syslogs,dump the transaction log. Otherwise, use ALTER DATABASE orsp_extendsegment to increase the size of the segment. (#1105)"I have looked at the database in SQL referred to and I notice that itsays there is 200 MEg allocated for the log size and 250 meg for thedata size and that in both categories there is "0" space available.When I select "EXPAND" on this page it takes me to a screen which hasa graphical presentation with a bar chart showing the available spacein red and the used space in blue on each of what it refers to as'database devices". There are 10 items shown--Temp_DB available space 30 used 30, Newplog 200 available 200 used,NewpDev 250 available 250 used, MSDBlog available 2.00 used 2.00,MSDBData 6 available 6 used, Master 50 available 50 used, Data_log2.00 available 2.00 used, Dale_data 12 available 12 "free space" (this one says free space instead of used?), Contact_log 25 available15 used, Contact_dev 100 available 75 used.So I can see on the first screen that there was 450 meg allocated tothis database called newpdatasql and that all 450 is being used. Andwhen I go to the next screen that shows the devices in this databasethat many of them show that their available space is completely used.The fix is probably to expand the available space for the database. Onthe second graphical screen that shows the bar chart there is anbutton called "expand now" that is greyed out except when you selectthe different devices in a drop-down box at the top of the screen.There are two drop down boxes -- one titled "data devices and onetitled log devices. THe only time the Expand now button is not greyedout is when I select "Dale_Data, "Contact_log", or "Contact_dev". Idid select the "contact_Dev" device clicked on expand and it seemed toI guess expand this device to a fully used level as after I did thisit says that the space available is still 100 meg ( see commentsabove) but now instead of 75 used it says 100 used! Progress or what?I guess I could do this for the other devices as well. One issue forme is whether when the space available for a device is the same as thespace used does this mean that it is at maximum capacity in terms ofdata or only that the space available on the disk for this device iscompletely being made available as potential storage space?Interestingly the original error message mentions "syslogs" and"logsegment" neither are available as devices or are named in thescreens relating to database expansion.Any help would be greatly appreciated.My tollfree number is 866-957 1081.Jeffrey Kilpatrick
Newbie SQL question - what logic does SQL Server use to place limits on the extendable size of a database device? I have gigs of room on a partition and I would like to extend a 1GB device to accomodate database growth - but for some reason, Enterprise Manager reads that the max size I can extend the device is only 600MB (when I have 4GB free on the partition). Am I just reading the tool incorrectly?
Microsoft SQL Server 2012 - 11.0.5532.0 (X64) Jul 14 2014 15:00:27 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
management->SQL Error Log-> list of error files are not expanding,Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
Okay, so i have a Dual Xeon SQL2k5 Server set up. it's got 4 10k RPM Raptor Drivers (160gb) on it all stripped together. my question is this, i was just doing all kinds of index tuning, and my server didnt have enough disk space to create 2two of the recommended adjustments. i'm curious, if i should just have those two indexes stored on the 1TB Backup array i have? (two 500gb 7200RPM drives)
or should i backup the database, and expand the Raptor Array and then restore the database and create the indexes?
i'm not really worried about down time as long as it doesnt exceed 2 days.
When running Enterprise Manager from my desktop pc to try and expand a database device I am unable to do so. The size shown is negative, and the max size is the same, with the 'Change Now' box greyed out. When I log on directly onto the server I can easily expand the db device. There is lots of free space on the server. Our set up is quite small with four NT workstations and two NT servers with SQL Server 6.5 on them. All these six machines are in the same workgroup. The workstations are on a separate floor to the servers, which are in the computer room. I have a feeling this is a networking issue. Can anyone suggest why this is happening?
Hi, I have created a 30 gb device_db and named it device_A.Then, I am only allocate 15 gb for my database in that device... My question is if I decided to expand the size of my database in device_A, is there any limitation of how much expansion I can use... for instance can I put 15000 in the Data Device to expand the size of the data base in device_A.... I am not sure if I have to use this in one step, as I explained before or I expand by 500 mb( which will take me 30 times)... any bright ideas
Is there any set option with which, the text output from select statement can be changed. A select of any varchar field defaults to 256 characters. If I define a field of varchar(1024), how can I get an output representing all the 1024 characters. Thanks
I have a user assigned multiple roles and a role can be inherited frommultiple parents (see below). How do I answer such questions as "Howmany roles does the user belongs to?"I answered the above questions by using .NET but I think it can bemore efficient by using just SQL. I would appreciate if you can giveme an answer.Thank you.CREATE TABLE [dbo].[tb_User] ([Id] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY,[Name] nvarchar(99) NOT NULL UNIQUE,[Password] nvarchar(99) NOT NULL,) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Role] ([Id] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY,[Name] nvarchar(99) NOT NULL UNIQUE,) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_User_Role] ([UserId] [int] NOT NULL ,[RoleId] [int] NOT NULL,) ON [PRIMARY]GOALTER TABLE [dbo].[tb_User_Role] WITH NOCHECK ADDCONSTRAINT [PK_tb_User_Role] PRIMARY KEY CLUSTERED([UserId],[RoleId]) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Parent_Role] ([RoleId] [int] NOT NULL ,[ParentRoleId] [int] NOT NULL ,) ON [PRIMARY]GOALTER TABLE [dbo].[tb_Parent_Role] WITH NOCHECK ADDCONSTRAINT [PK_tb_Parent_Role] PRIMARY KEY CLUSTERED([RoleId],[ParentRoleId]) ON [PRIMARY]GO
Hi friends, I am doing a matrix report. in this report the matrix can extend to either 1 day or it can extend to 28 days depending upon the range of parameter we give. example: if we give range of date 7/16/2007 - 7/16/2007 then only 1 column of data will come but if i give the date range as 7/9/2007 - 8/5/2007 then 28 columns will come as 28 days are selected. i have given the body of the report such that it accomodates all 28 columns. i have few labels that i have to keep on the page header. the width of these textboxs i have given same as the matrix width when it will have 28 columns. in pdf exports the labels in the export comes aligned with the matrix when 28 columns are selected but in html the matrix expands. so it does not look aligned with the labels in the page header. I hope the above explanation is clear. can anyone help me on this. Thanks.
Microsoft SQL-DMO (ODBC SQLState: 42000) Error 1827: CREATE/ALTER DATABASEfailed.There's more, but it's in italian and I wouldn't know how to translate itproperly.It basically says that the requested size is exceeding some 2048mb limit.I can't see any limitation of this kind in the license. Is there something Iam missing here?Thank you in advance- andrea
Pleeeease help? I get an error when expanding the Tables object under linked servers in Enterprise Manager on a MSSQL2000 server.
I have a standard install of the Pervasive.SQL V8 data engine and DemoData db on my local PC. The SQL Server is also on my local PC.
I manage to create the Linked Server using the MSSQL Enterprise Manager. I used the following configuration:
Provider Name: Pervasive.SQL V8 OLE DB Provider Product Name: Pervasive.SQL V8 Data source: DemoData Provider string: <blank> Location: workstation03 Catalog: <blank>
However when I try to expand the tables object under Linked Servers in the Enterprise manager I get the following error.
Error 7311: Could not obtain the schema rowset for the OLE DB provider 'UNKNOWN'. The provider supports the interface, but retuns a failure code when it is used. OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80040155 ].
Hello Everyone, I am trying to expand the multi-valued parameter menu object so I can display the selection list in a more user-friendly format since the text is fairly long. If left at the default setting then I have to scroll to the right to see the complete string(s). For a single-select parameter I can just CAST the string to CHAR(100) and the menu object will expand. However, it seems that this approach is not working for multi-valued parameter menu objects. Is this a bug in SSRS, and is there another way to accomplish this. Please let me know.
I have a report with a single table, single grouping level, single data set and no sub-reports. It has 3 rows for a grouping header and 3 rows per dataset row of detail. The detail rows are initially hidden and can be expanded by clicking on the header +. Its a fairly standard master-detail report.
Regardless of data size, I get NO page breaks in HTML. I have the Interactive size set to 8.5x11, KeepTogether is set to False, and PageBreakAtEnd is set to False. I would like it to break based on the visible grouping rows.
As it is now, everytime you expand any section, it takes forever to reload for a larger recordset.
I know that "HTML renderer and Preview (which are soft page break renderers) will ignore page breaks of conditionally hidden items and their children.", but how do I get this report to page break?? I've seen a lot of posts on this, but none that seem to have an answer.
I have a reportviewer on a master page in a VS2008 ASP.NET application. When I originally created the page, I did not use a master page. When I moved the code to a master page, the Toolbar is 6 line long instead of 1. Each of the individual components of the ReportViewer toolbar is placed on it's own line. (i.e Navagation, Print, Zoom, Etc.) The same control worked correctly on it's own page.
hi guys help please. I have a column name Quantity of type int in my table table1 and it has an intial value say 5. My question is, is it posible to update that column say, i want to add 10 from its initial value for it to have a value of 15, without querying it first from my application and store it to a varibale and add 10 to it for it to have 15 and execute update to set the initial to new value (15).
I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see: - A dropdown of different connection strings, to connect to different databases -A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once) -A gridview object for results -A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc) I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)
There are certian "routine things" that need to be queried in my database. Currently we can either do:
1) SELECT * FROM myTable WHERE id = x
OR
2) We can use a stored procedure to do the above SQL for us...That way, if the table changes, or we make changes to the database etc. The calling code will remain unchanged and we just have to change the stored procedure code instead of anywhere that calls it.
What would you say are any disadvantages of doing the 2nd approach?
I am using SQL RS 2005 with VS2005 in Windows Application. I have placed Report Viewer on Windows From and then report is attached with it. Now report previews well in BIDS as well as in VS2005. Moreover it exports perfectly to pdf and excel but when I click print button on report viewer and give direct print to printer, font size, textbox, rectangle and every other thing become large, like instead of 10 font size, it prints 12, instead of 240 width of rectangle, it prints 280 or so.
There must be some solution to this thing. Some one help
hi all, I am using SQL reporting services 2005, i like to have a parameter as optional, is there is any diresct way to set a parameter as optional without setting through the default value.
I have found article by Jamie T. (www.sqlis.com/26.aspx) where he explains how to use direct configuration.
I followed every step.
Before building project I made sure that CreateDeploymentUtility = True.
Once project was built I have copied files from Deployment folder to other PC to c:PackageConfiguration (I have 3 files there: environment.dtsconfig, PersonAge.dtsx and jamie.SSISDeploymentManifest)
However, I am doing something wrong as I was not able to deploy this to another PC.
I double click Manifest file and in Configuration Package - Property there are two entries: InitailCatalog and ServerName. Initial Catalog has Value=DataStore and ServerName = MyPCsql2k5local. I change ServerName to be AlexPcSQL2k5Local.
I have Validate Package after instalation so I get error saying that connection to Destination failed.
If I go to File System to installed package and say Run, package will run OK if I change all ConnectionManagers to point to AlexPcSQL2k5Local
I have recently upgraded to report Server 2005. I used to have a webpage that loaded a number of reports into different frames to give real time statistics for an IT Service Desk.
In the new version if try and link directly to the report (By right clicking a report and taking the link) the report loads with out any of the toolbars etc at the top as i need it, however it does not refresh and seem to be cached data.
Has anyone got any ideas how to resolve this problem, in short all I need is a way to directly view the report losing all the toolbars etc on the top and just displaying the data.
This has been driving me mad so if anyone could help i would be really grateful!
I have a SQL 2000 table in which pictures are stored as an Image column. I want to display then onto a c# aspx webpage without storing them to disk. What is the best way to read and display the pictures? In classic ASP I used to do this: Response.ContentType = "image/jpeg" Response.BinaryWrite rs.fields("ThisImage") but I can't get this to work in c#.
If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?
I am modifying the connection string with the XML. My strategy is to set up an XML configuration for each database that we have. The Dev XML config will point to Development connection, UAT to UAT etc..
My thought is that by using the direct configuration it will eliminate the need for environment variables and also allow me to add configs without having to reboot the servers, which you would need to do in order to get server to recongize the EV.
I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.
One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!
Does anybody have any ideas about how this could be happening ?
Is it ok to have users directly updating on the server and users synchronising ?
