I have an issue with backup / restore process. The issue as under:
I have a SQL Server 2005 Database in Production, for which InitailSize is set to 60 Gig. Infact the DB is not that big and when i have taken the full backup of this database, The backup file size is shown as 1 gig only.
Now the issue is, My QAT environment doesnot have 60 gig free space. it has only 10 gig of free space.
I want this DB to restored in QAT environment with initial size say 4 or 5 gig. how will i do that?
Script for the same would be appreciated.