Thursday, August 22, 2013

[MS SQL Server] SSIS Question Help

[MS SQL Server] SSIS Question Help

SSIS Question Help

Posted: 22 Aug 2013 03:13 AM PDT

Hi Guys, I have question. I am creating a SSIS Package, Its runs fine with no problem, Its kinda simple package, Let me explain...Pulling the data from SQL Table and my destination is flat file (First flat file). Here i want one more logicI want to create one more flat file with below information1) Count from First flat file2) Flat file name (Naming convention change "Flatfilename_getdate()" from first flat file3) Time when Package run..Is anyone can help me

Server reboot...missing drives

Posted: 22 Aug 2013 01:00 AM PDT

Last weekend we applied some updates on a prod server and rebooted it. After the reboot when we connect to the server, two of the databases went to suspect mode. Later realized the log file drive got disconnected. Had to rescan the disks and reboot again in order to bring back the databases up. We want to avoid this issue in future. What's the reason behind this behavior and how to fix it ? OS- Windows server 2008R2 SP1SQL- SQL server 2008 sp3

Unistall Named Instance Only

Posted: 22 Aug 2013 03:59 AM PDT

We have a named instance of SQL Server 2008 R2 which was installed to support a single application. The instance is on a server that also has a default instance hosting databases for several other applications.The application using the named instance (named for the application) is no longer used. Is it safe to uninstall the named instance without risk of damaging the default instance, or are we better just off opening SQL Configuration Manager and setting the Startup Mode of the named instance to "Disabled?"

Multi node multi instance clustering Drive letters

Posted: 22 Aug 2013 12:52 AM PDT

we have a two node one instance cluster in our environment. Planning to make it multi node multi instance. Currently on each instance we have around 8 different drives. We are thinking of 4 node 3 instance clustering, so total drives will be around 24 drives. But as I see there are only 17 drive letters to choose from. How to configure the 4 node 3 instance cluster with all 24 drives ?

xml file creation and auto updation from sql database

Posted: 21 Aug 2013 04:43 PM PDT

Hi,we are trying to generate xml file to a particular location from sql server 2008 tables and we want to auto update that xml file on a particular time intervals at that location only (as sql data updated we need auto updation of that xml file).

Doubts about dbcc shrinkfile working

Posted: 21 Aug 2013 07:04 PM PDT

Hi friends i wanted to know about behaviour of dbcc shrinkfile command dbcc shrinkfile(2,10)now 2 denotes that i want to shrink log file but what i wanted to know about is size to which it decrease.It know size is in 10 mb.But what i wanted to know is whether size would reduce by 10 mb or reduce to 10 mb.for eg suppose log file size is 100 mb.then after executing above command would log file new size would be 10(100mb to 10mb) mb or 90 mb(100mb-10mb)Thanks and RegardsAnoop ps. I know shrinking is bad but still want to know about it
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog