Skip to main content

Return to Question

removed noise
Source Link
WhatsThePoint
WhatsThePoint
  • 3.6k
  • 11
  • 35
  • 58

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day iI have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so iI want to copy it to development server with a real time data and on development server iI can do anything without impacting to production server db.

canCan anyone suggest better way to doing this.?

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with a real time data and on development server i can do anything without impacting to production server db.

can anyone suggest better way to doing this.

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day I have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. I want to copy it to development server with a real time data and on development server I can do anything without impacting to production server db.

Can anyone suggest better way to doing this?

'thanks in advanced' (https://meta.stackoverflow.com/questions/288160/no-thanks-damn-it)
Source Link
edit approved Jan 27, 2023 at 11:04
nquincampoix
edit approved Jan 27, 2023 at 11:04
nquincampoix
  • 803
  • 1
  • 8
  • 19

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with a real time data and on development server i can do anything without impacting to production server db.

can anyone suggest better way to doing this.

Thanks in advanced.

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with a real time data and on development server i can do anything without impacting to production server db.

can anyone suggest better way to doing this.

Thanks in advanced.

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with a real time data and on development server i can do anything without impacting to production server db.

can anyone suggest better way to doing this.

Proper format.
Source Link
edit approved Feb 4, 2016 at 4:30
Mr. Engineer
edit approved Feb 4, 2016 at 4:30
Mr. Engineer
  • 3.5k
  • 4
  • 19
  • 34

I want to copy prodproduction server database to Development server, I am using backup and restore to take prodproduction server db to Development server.

I have restorerestored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with ana real time data and on development server i can do anything without impacting to prodproduction server db.

can anyone suggest better way to doing this.

thanksThanks in advanced.

I want to copy prod server database to Development server, I am using backup and restore to take prod server db to Development server.

I have restore it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with an real time data and on development server i can do anything without impacting to prod server db.

can anyone suggest better way to doing this.

thanks in advanced

I want to copy production server database to Development server, I am using backup and restore to take production server db to Development server.

I have restored it successfully and added tables and SP in restored DB. Again next day i have to restore same database, after restore my existing tables and SP will get deleted.

I can not use SP and extra tables on production server DB. so i want to copy it to development server with a real time data and on development server i can do anything without impacting to production server db.

can anyone suggest better way to doing this.

Thanks in advanced.

Source Link
Jack
Jack
  • 520
  • 3
  • 8
  • 25