InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 06:43:11 GMT20http://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxIt looks like you have 2 options.1. get more space2. Have the prod dba import the data for you (as mentioned above)I doubt they would shrink a production database as that could cause fragmentation and it was probably created that large for a reason.Fri, 04 Sep 2009 08:17:48 GMTSteve-3_5_7_9http://www.sqlservercentral.com/Forums/Topic781529-357-1.aspx[quote][b]Sudeepta (9/3/2009)[/b][hr]You have a full backup of size 1GB. Create a database on the QA environment with the same logical file name as of the Production DB. Restore the database and then shrink it.Script:[code="sql"]RESTORE DATABASE [DATABASE_NAME]FROM DISK = 'Path_of_the_backupfile',MOVE 'Logical_datafilename' TO 'Physical_datafile_location',MOVE 'Logical_logfilename' TO 'Physical_logfile_location',REPLACE GO[/code][/quote]The initial size of the file is 60 GB and They don't have that much space on their QA Server. :unsure:Thu, 03 Sep 2009 02:45:38 GMTSarab_SQLGeekhttp://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxYou have a full backup of size 1GB. Create a database on the QA environment with the same logical file name as of the Production DB. Restore the database and then shrink it.Script:[code="sql"]RESTORE DATABASE [DATABASE_NAME]FROM DISK = 'Path_of_the_backupfile',MOVE 'Logical_datafilename' TO 'Physical_datafile_location',MOVE 'Logical_logfilename' TO 'Physical_logfile_location',REPLACE GO[/code]Thu, 03 Sep 2009 02:10:42 GMTSudeeptahttp://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxas per my knowledge [b]NO[/b]but you can ask the prod team to export the prod data to new DB of your QA Server.Wed, 02 Sep 2009 10:42:26 GMTSarab_SQLGeekhttp://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxFirst option is not possible, because prod environment is not in my control.Second, I will be getting the backup file only from production, nothing else.Any changes can be performed in QAT while restoring. Please let me know if this can be done ( i mean change the initialsize to 3 mb while restore itself).....I have the access only to QAT to make any changes while restoring.Wed, 02 Sep 2009 09:09:41 GMTJushttp://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxThere are many ways to resolve this:Ist is try to shrink this DB and then take a fresh backup which can be restored at the destination(QA) Server. [but this can result in fragmentation]2nd is if the DB has only 1GB of data you should create a fresh DB with initial size 1 GB and do enable the autogrowth but only by 10% and then shift all your data to that DB and then take a fresh backup and restore it.Wed, 02 Sep 2009 09:02:44 GMTSarab_SQLGeekhttp://www.sqlservercentral.com/Forums/Topic781529-357-1.aspxHello Guys,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.--JusWed, 02 Sep 2009 08:40:17 GMTJus