SQLServerCentral / Discuss Content Posted by Vince Iacoboni / Article Discussions / Article Discussions by Author

Moving the SQL 2005 System Databases

viacoboni — Mon, 25 Sep 2006 12:44:00 GMT

Comments posted to this topic are about the content posted at temp

Moving System Databases

NetEng81 — Mon, 21 Jul 2008 11:44:47 GMT

Hi Vince,I am fairly new to SQL Server 2005 Administration. I am running low on disk space on my C: drive where all the system databases recide. Can you please help me with the script so I may move the files to an alternate drive? What changes do i need to make?All my system database files (primary data file as well as log files) are located under the default location: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DataI need to move the data files under D:\program Files\Microsoft SQL Server\Data folder and the log files under D:\program files\Microsoft SQL Server\Logs folder. All the databases that I created already locate on a separate drive (on the SAN). I am not very confident in the process of making this chance. Any help would be appreciated. Thank you.

Is Vince Iacoboni still around?

Luis Cabrera-257608 — Thu, 17 Nov 2005 12:26:00 GMT

I just downloaded his sp_ABBackupRestore.zip stored procedures that he created back in 1998. I started using them on a test server and they work really good. I would like to know if there is an updated version from his original post or if there is a new one for SQL Server 2005? I hope he's still around...

Thank you.

Get And Set SQL Server 2005 Instance Registry Values

viacoboni — Tue, 03 Jul 2007 09:52:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/vIacoboni/3092.asp

More Intelligent Backup and Restore

viacoboni — Tue, 25 Oct 2005 16:43:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vIacoboni/moreintelligentbackupandrestore.asp

Executing cmd file with isqlw command imbedded, want to change output file delimiter

terrell.sharp — Mon, 17 Mar 2008 14:02:30 GMT

I am running isqlw in scheduled command files. I have many vendors I SFTP files to within those command files. They require different output delimiters. Can you change the SQL Analyzer configuration from TAB to PIPE delimiter dynamically in the command file?

copying partial data between servers

Kristen Bates — Tue, 06 Nov 2007 08:50:50 GMT

I need a way of restoring partial data from our Production database to Development. The Production database, EDS, is 1.5 TB containing 180 tables all partitioned on the same scheme by month. Every month of data is about 100 GB. The primary filegroup only contains system tables. Every month is in it's own filegroup, currently with 8 files in each filegroup. On Development, we only want to store 1 month of data. This is so we can save time in syncing Dev to Prod, and also save storage space on Development. The developers need the Dev environment synced to Prod quite often, every 1-2 weeks, and we need a way to do that that takes <= 4 hours. There are frequent DDL changes between Dev and Prod, so we need a method of syncing the two databases that will include DDL changes as well as data.Everything I have tried has failed. All attempts to backup a single filegroup on Prod and restore that one filegroup to Dev failed because SQL Server did not recognize the backup as being from the current backup set. So I am trying to find a way to trick the system by not using backups, but just copying the files. My latest experiment was this:1. create empty EDS database on Dev that matches Prod exactly - same table structure, same partition scheme, same data file names and locations, etc. 2. take Prod offline3. copy the 8 data files for the selected month, and also the primary file and the log file into a separate folder.4. bring Prod online5. detach Dev EDS database6. copy and paste the 8 data files and the primary data and log file over the existing Dev files7. Attach the database.8. Error: "One or more files does not match the primary file for the database".Is there some other method that might work? I have not tried the partial backup or piecemeal backup methods and don't know much about them. Let me know if anyone has any ideas.

Need Help !

abmore — Wed, 03 Oct 2007 06:49:12 GMT

myID myVal minTic maxTicticCount---- ------ --------- --------- --------- 1 A 0.20 1.500.12 B 1.00 1.001if object_id('tempdb..#tmpValues') is not nulldrop table #tmpValuescreate table #tmpValues(myIDtinyintidentity(1,1),myValvarchar(10),minTicnumeric(5, 2),maxTicnumeric(5, 2))insert #tmpValues( myVal, minTic, maxTic )select 'A', 0.2, 1.5unionselect 'B', 1, 1select * from #tmpValuesif object_id('tempdb..#tmpValues') is not nulldrop table #tmpValues========================================Output required ::myID myVal minTic maxTicticCount---- ------ --------- --------- --------- 1 A 0.20 1.500.12 B 1.00 1.001