Can I take a snapshot of a file on an AS400 system using SQL Server 2005

• Brandon Carl Goodman

  SSCrazy

  Points: 2458

  More actions

  November 15, 2008 at 12:51 pm

  #193861

  Would like to take a snapshot of a file that is on an AS400 system. It is possible to do and what is the exact syntax...

  CREATE DATABASE CustomBalStat

  ON

  (NAME = BalStat_Data,

  FILENAME = 'C:\CustomBalStat')

  AS SNAPSHOT OF "AS400.TEST.SQL_TEST.TESTFILE"

  Just wanted to know if indeed was possible. Curious.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 17, 2008 at 2:19 pm

  #899566

  No you can't take a snapshot of anything besides a SQL Server database.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question