Transact SQL :: Move Files From One Location To Another Using Powershell

Jul 12, 2015

I have a job which copies .txt files 24 hours 7 days a week to c:TempSource

What I am planning to do is copy the files from one location to another say c:TempTarget

So I have written the Powell shell script and when i put that in the sql agent job i get below error ;

A job step received an error at line 5 in a PowerShell script. The corresponding line is '$filesToMove = $files | Where -Property "Name" -NotLike -Value $newestFile.Name'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'A parameter cannot be found that matches parameter name 'Property'. '. Process Exit Code -1. The step failed.

$sourceFiles = "c:TempSource*.txt"
$targetFolder = "c:TempTarget"
$files = Get-ChildItem $sourceFiles
$newestFile = ($files | sort LastWriteTime -Descending)[0]
$filesToMove = $files | Where -Property "Name" -NotLike -Value $newestFile.Name
$filesToMove | ForEach { Move-Item $_ $targetFolder } 

View 12 Replies


ADVERTISEMENT

SQL Server 2008 :: Powershell Script To Move Backup Files

Feb 11, 2015

I am trying to create a job using power-shell script to move the backup files from one folder to another. I am using Ola Hallengren script for backups. Ola hallengren created a common backup folder with sub-folders for databases and even more sub folders for Full and Log backups. My goal is to move full backups, which are older than a month and save them in a different drive along with the same folder structure. I was able to move the first set of backups without any problem, but I can't move anymore files and keep getting this error even when I try to overwrite the previous file with the force statement:

Move-Item : Cannot create a file when that file already exists.

At line:5 char:9
+ Move-Item $i.FullName C:Test -force
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (C:BackupVALIDATIONgcommon:DirectoryInfo) [Move-Item], I
+ FullyQualifiedErrorId : MoveDirectoryItemIOError,Microsoft.PowerShell.Commands.MoveItemCommand

Here's the script that I used to move the first set of files:

foreach ($i in Get-ChildItem C:BackupVALIDATION)
{
if ($i.CreationTime -lt ($(Get-Date).AddMonths(-1)))
{
Move-Item $i.FullName C:Test
}
}

View 0 Replies View Related

Move Mdf Files For System Databases To Another Location

Mar 18, 2008



Hello there,
I've been told that it is good practice to keep mdf and ldf files in another location... We have it in place for all our user databases, however mdf and ldf files for our system dbs are still at the same location. I was wondering what is the right way of splitting those should be?

View 5 Replies View Related

Transact SQL :: Multiple Queries On Various Database Using Powershell

Oct 19, 2015

As a part of DBA, I used to execute various SQL files. Most of the time, it is like a manual effort to execute the files individually.

I am looking to automate the process, like a single click to execute all the .SQL files.

The main hurdle I have is, some files needs to be executed in A1 database, some in B1 database and some other SQL files need to be executed in C1 database. In this scenario, I need to pass the DBName information to the powershell query dynamically.

My design for this requirement is, say each .SQL file need to contain a template like

@DBName = 'your Database name'
@Executeon = 'When to execute'

In this case, the powershell first need to read the SQL file and finds the value for @DBName and replace it in the powershell query and execute the SQL files automatically.

Is it feasible ? Or any other alternate easier way to proceed.

View 3 Replies View Related

Move Index File To Different Location

May 19, 2008

I want to move index file(69 gb) to different location.Right now data and index files are on the same drive(e), I am trying to move index files from e drive to f drive, so I will get 69 gb free on e drive . Can anyone please advise me what precautions I should take and advise best practice.

Thanks in advance

View 2 Replies View Related

Move Reports To Diff. Location

Oct 15, 2007

Dear gurus,

I have the reports in https://reports.yyyy.com/reportserver
Now I want to point out to https://reports.yyyy.com
How can I do that?

I dont have any rdl files. Is it possible to move the reports?
I am very new to SSRS

Thanks
Krishna

View 7 Replies View Related

Recovery :: Move 2012 VM To Different Location

May 4, 2015

i have Two SQL 2012EE Node , it is installed in VCE Vblook 100 , now i want to move it to another hardware my question is " How i can i achive this task by move Windows 2012 R2 Cluster and SQL 2012 EE Cluster to another hardware".

View 4 Replies View Related

Transact SQL :: Update Query In Powershell From Excel Sheet

May 12, 2015

I am trying to update my SQL table using an update query in powershell from an excel sheet.

The query is as follows,

#building name from excelsheet
 $TCell=$reader.GetValue(8);
#update query is as,
 $CreateScript1= "UPDATE $DestinationTable SET $DestinationTable.Phone = '$SCell' WHERE RoomNumber = '$FCell' and buildingname
like ''$TCell'%'"

I want to use like operator in the query to compare building name from excel sheet with the building name in sql table. I am facing an error in the highlighted part. I am not sure if my query is right or wrong.

View 2 Replies View Related

Transact SQL :: Powershell For Pass Comma Separated List

Sep 8, 2015

I have a requirement, we need to pass comma separated list using powershell script.

How can we achieve the above scenario?

View 3 Replies View Related

SQL Server 2014 :: How To Move AG Databases To New Location

Jun 27, 2015

I would like to move my AG databases to new location using C#.I found article on MSDN which uses SQLCmd utility to do that, but I cant run that utility from my application.I am looking for general steps OR T-SQL if possible so that I can follow the same from my C# application.

View 6 Replies View Related

Transact SQL :: Server Is Cutting Off Result-output Running A Powershell Script

May 7, 2015

I want to run a powershell script using xp_cmdshell, put the results into a temp table and do some additional stuff.I'm using:

CREATE TABLE #DrvLetter (
iid int identity(1,1) primary key
,Laufwerk char(500),
)
INSERT INTO #DrvLetter
EXEC xp_cmdshell 'powershell.exe -noprofile -command "gwmi -Class win32_volume | ft capacity, freespace, caption -a"'
select * from #DrvLetter
SQL server is cutting off the output, what I get is (consider the 3 dots at the end of a line):
 
[code]....

View 2 Replies View Related

Transact SQL :: Powershell Script To Fetch Database Usage Details For Multiple Servers (report)

Oct 28, 2015

Is there a way to fetch database usage details for multiple SQL servers (report) usirng powershell script.

Details: servername, databasename, datafile usage, logfile usage, free % age...etc.

View 3 Replies View Related

Location Of .MDF And .LDF Files

Mar 27, 2007

Does anyone know where a good article pertaining to where you should locate your Data and Log files (in SQL Server 2005)?
I read an article several years ago stating that Log files should be on a seperate RAID 1 and Data on a seperate RAID 5.
Anyway, any help is appreciated.

View 1 Replies View Related

How To Separate Data's And Log's Files Location.

Sep 26, 2000

Hi everybody,

On the time of installation SQL Server asking me where I wont to locate the DATA files and the PROGRAM files. It�s giving to me choice to put database AND log files on one disk and program files on separate. But what about to separate LOG and DATA files. I have RAID1 especially created on F: drive for LOG files and RAID 5 on E: for DATABASE files. When I have to separate that if not on the time of installation? How I can do that?

Thanks,
Miriam

View 3 Replies View Related

Change Location Of Template Files

Aug 8, 2006

In SQL2000, there's an option to change the location of the template folder. This allows me to create a customized set of templates on a network folder and have all the developers reference the centralized location. Can the same be done in SQL2005 and how would I go about doing so?

Thanks.

View 1 Replies View Related

Copy Folders And Files To Different Location

May 15, 2007



I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location.



e.g., C:MainFolderMar01 ==> Multiple files in Mar01 folder

C:MainFolderMar02 ==> Multiple files in Mar02 folder



Does any one know the best way to do this in SSIS?



Thanks in advance.



BC

View 1 Replies View Related

Data Files Path Not Location

Jan 28, 2008



Hi All,

Can plz any one help me, acutally as i know sys.files table gives you the acutally physical location of the database fiels with name as well like this

C:sqldatax.mdf

but what i m looking is, is there any qury or script that will give me only the path of the data,log, index files like this

C:sqldata

Thanks and looking forward.

-MALIK

View 5 Replies View Related

DB Engine :: System Database Files Location

May 16, 2015

I have C,D,E drives on server. Data files will be on D and Log on E. My question is what is best practice for data and log files for system databases during sql server installation selection? Should they be on C drive along with SQL Server installation or D & E? If they should not be on C then what is the reason and what is benefit to move them on other drives.

View 9 Replies View Related

SQL 2012 :: SSIS To Load Files From Two SFTP Location

May 18, 2015

How to load files with similar format , from two different locations into same database with same ssis.

Lets say
Location 1: C:LoadFilesCust1APP_123445.txt
Location 2: D:LoadFilescust2VDD_543121.txt

Currently we have one ssis which loads and process files from C:LoadFilesCust1 only. we have to modify the existing package it to load files from Location 2 (D:LoadFilescust2) as well. Also while loading, the ssis should assign a value to existing column CustID depending upon the file name. File names always start with APP_ in first location. VDD_ in second location

Assign CUSTID as 100 if file name starts with APP_
Assign CUSTID as 200if file name starts with VDD_

View 1 Replies View Related

Location Of Default Instance SQL Server 2005 Files

Dec 21, 2005

I have just installed SQL Server 2005.  I was not given a choice during installation (that I remember seeing anyway) about which drive I wanted to place the default SQL instance on.

It ended up on C: and I needed it on D:.

 

So my questions are:

Is there a way to move it to D: that is easier than the way you had to go about it in SQL 2000?
Is there a way to do it during setup so I can avoid this in the future?

View 7 Replies View Related

Processing Last Created/modified Files From A Location Using SSIS Package

Mar 12, 2008

We have a scenario to process last created/modified files from a location using SSIS package , eventhough the folder contains multiple files with same name and extension.

Kindly give respond to this if any one has worked on this.

Regards,
Sajesh

View 7 Replies View Related

Copying Files From A Sharepoint Location To Local Machine Using SSIS

Apr 20, 2007

I have to copy files from a sharepoint or extranet location (basically https://.....) location to my local server using SSIS.



Any kind of early help would be really great.

View 1 Replies View Related

Move Log Files

Apr 23, 2001

Can someone tell me how to move the log file for a database from one drive
to anoyher. I want to keep the data on one drive and the logs on another
so I need to move the log files to another drive.
Thanx, Kelly

View 1 Replies View Related

Move Files

Jun 13, 2001

Without restoring the database, has anyone written a slick little piece of code that moves a file existing on on filegroup to another newly created filegroup without doing it from a restore.

The purpose of doing this is to get rid of one data file and placing the data into the data file we are retaining. We have some more physical file space and are moving data into one data file and one transaction log file.

We have already ran the DBCC SHRINKFILE with EMPTYFILE to move the data,
We have already ran the ALTER DATABASE statement but here, because the filegroup is identified as PRIMARY in the sysfilegroup table, we can not REMOVE the data file because of indexes relating to the PRIMARY filegroup.

So if I could ALTER DATABASE and create a bogus filegroup and move the data file which I want to get rid of into the bogus filegroup, I could ALTER DATABASE with REMOVE filegroup and solve the situation.

Does anyone know of an easier way to do it other than BACKUP database and RESTORE database.....please help!!!

Thanks,
Daimon

View 1 Replies View Related

How To Move Files Between Servers?

Sep 9, 2004

Can I move a database from one server to another server using QA?

EXEC sp_detach_db @dbname = 'IISLOG'
EXEC sp_attach_single_file_db @dbname = 'IISLOG',
@physname = 'c:Program FilesMicrosoft SQL ServerMSSQLDataIISLOG.mdf'

Or would I need a tape backup to move this database to another server?

Thanks

Lystra

View 1 Replies View Related

How To Move Data Files

Jul 20, 2005

hello,my problem is how to move data files drom drive c: to drive d: ??--MarcinS

View 1 Replies View Related

Move Objects Between Mdf Files

Apr 1, 2006

what is the easiest way to move objects (tables with data and stored procedures) from one sqlexpress database mdf to another mdf?

View 1 Replies View Related

Move Bad Files To Error

Oct 1, 2007

Hi,

I am looping a set of .txt files in a folder using foreach.

Inside foreach, I have a Dataflow task that does the transformation. After that i have added a File System that moves file to archive.

However, If the user puts any other file instead of a .txt file, i want to move the file to Error folder and this should be before the DataFlow starts within foreach.

How can i do this? I want to use script to read the file extension and then move it to the error.

Lalit.

View 8 Replies View Related

SQL Server 2008 :: Find Date Created And Modified Values Of All Files In A Location

Jun 11, 2015

Script to find the details of creation date and modified date of all files located in a path?

I wanna write few custom messages before I delete some files from a path.

View 9 Replies View Related

Need To Move Data And Log Files To A Different Drive?

Jul 3, 2001

View 1 Replies View Related

How To Move Files From C:dirf2.mdf To E:dirf1.mdf

Oct 17, 2003

Hi ,


I created a few databases but I forgot to change the location from c:program filesd1.mdf.I don't have much space left on c: drive but have lot of space left on e:

How do I move the data and log files to e: drive ?

Thanks,
Sal

View 1 Replies View Related

Move Mdf/ldf Files For A Replicated Database

Jul 23, 2005

Can someone lend some assistance in this? It sounds like it should beable to be done.We have a large replicated database in SQL 2000. We need to move themdf and ldf files to a location on another drive.Will doing this affect or break replication in any way? Is there anyway to prevent this?Thanks in advance.Glenn DekhayserVoyant Strategies

View 1 Replies View Related

Move Files In Data Flow

Sep 7, 2007



Hi all,

I'm trying to find some way to implement a move file task in my Data Flow. I parse through a flat file, retrieve a value, then I'm using a lookup table to check if that value exists in a table... if the value doesnt exist, I need to move this file to a new directory and insert the value into a different table. Does anyone have any ideas about how to move the file while using the Data Flow pane?

Or is there some way to pass information from the look up table to the Control flow pane and use the Move File Task there? I'm trying to stay away from a Script task or a Script component unless it's unavoidable. I appreciate any ideas!

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved