Move row string to column

  • Thread starter Thread starter atran4
  • Start date Start date
A

atran4

Hello

I need help to the column string to row. Here is the example of the
data.Thanks


(Policy DB1 Backup Policy for backup time 10:30 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 10:30 AM today
Job completed at 10:31 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 4 changed, 0 new, 0 deleted
Backup duration was 35 seconds

Policy DB1 Backup Policy for backup time 10:15 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 10:15 AM today
Job completed at 10:16 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 5 changed, 0 new, 0 deleted
Backup duration was 51 seconds

Policy DB1 Backup Policy for backup time 10:00 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 10:00 AM today
Job completed at 10:01 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 4 changed, 0 new, 0 deleted
Backup duration was 23 seconds

Policy DB1 Backup Policy for backup time 9:45 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 9:45 AM today
Job completed at 9:46 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 4 changed, 0 new, 0 deleted
Backup duration was 23 seconds

Policy DB1 Backup Policy for backup time 9:30 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 9:30 AM today
Job completed at 9:30 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 4 changed, 0 new, 0 deleted
Backup duration was 16 seconds

Policy DB1 Backup Policy for backup time 9:15 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 9:15 AM today
Job completed at 9:15 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 6 changed, 0 new, 0 deleted
Backup duration was 18 seconds

Policy DB1 Backup Policy for backup time 9:00 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 9:00 AM today
Job completed at 9:00 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 3 changed, 0 new, 0 deleted
Backup duration was 14 seconds

Policy DB1 Backup Policy for backup time 8:45 AM today

Job Configuration
Run the policy continuously up to a frequency of every 15 minutes
Using LiveVault Agent 5.4 Build 2416 with DynamicDeltaâ„¢ Optimization

Rules
Include C:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\JOBS\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\REPLDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\LOG\*,
Interpretation:All in directory, recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL
Server\MSSQL$DBINSTANCE1\FTDATA\*, Interpretation:All in directory,
recursive:Yes, Any case
Include G:\Program Files\Microsoft SQL Server\MSSQL$DBINSTANCE1\Data\*,
Interpretation:All in directory, recursive:Yes, Any case

Job Details
Policy started at 8:45 AM today
Job completed at 8:45 AM today

Backup Summary
Total data backed up: 441 objects, 118.46 GB
Objects changed in this backup version: 4 changed, 0 new, 0 deleted
Backup duration was 16 seconds

Policy DB1 Backup Policy for backup time 8:30 AM today
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Backup problems with MSSMLBIZ 2
Stupid Question of the day...... 4
SQL fails to start after install .net 3.5 5
Backup MSSQL db from C# code using SMO without knowing server version 7
Regular Expression: how to get Filename from Path 4
SideBySide, Resolve Partial Assembly failed for Microsoft.VC80.ATL 3
Trying to restore a .bak in C# 3
can't install BCM 2

Back
Top