parttioning

• rino.raju

  Grasshopper

  Points: 18

  More actions

  June 7, 2010 at 3:50 am

  #140769

  Hi,

  pls help me out for this

  use master

  go

  create database testdb

  on primary

  (name=test_part1, filename='c:\partitionpractice\test_part1.mdf',size=4mb,maxsize=100,filegrowth=1),

  filegroup testdb_part2

  (name=testdb_part2,filename='c:\partitionpractice\testdb_part2.mdf',size=2mb,maxsize=100,filegrowth=1)

  go

  use Northwind

  create partition function partfunc1 (int)

  as

  range left

  for values(10)

  use Northwind

  create partition scheme mypartschm

  as partition partfunc

  to ([primary],[testdb_part2])

  after running the partition schema m getting error AS

  Invalid object name 'testdb_part2'.

  pleas folowup m for...............................

• pvenkatesh2k4

  SSC Rookie

  Points: 36

  More actions

  June 7, 2010 at 6:19 am

  #1177041

  To ensure that file group is exist or not , Right click on the database-->properties --> file group

  check whether the file group testdb_part2 is exist...