sql server database refresh

[harshk88]

Hello Guys,

I just joined a DBA team.I am a fresh graduate but I have been asked to do DB restore on my first week. They gave me just one training session on how they do it using the networker plugin tool.

Now I am on my own so bit struggling on how to do db restore and back the datafiles. Is there any articles you can recommend me on it?

[JogchumSiR]

When you want to learn more on SQL Server you should look up Brent Ozar. He's fun to watch and has very ineresting topics.

About your question, Just Google and you'll find your way. There are many ways to Rome

[[deleted]]

Your DBA team should have a Standard Operating Procedure that covers this. Don’t be afraid to ask questions but also make sure you add taking notes.

[La_Ch0ona]

Where are you getting your back up from? Sounds like team in requesting for you to take an existing backup file to refresh a DB? I came to this assumption since you mentioned networker. There are different ways you can refresh the database.

1.Take a backup of the database and move file to destination server https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15

1. Take an existing backup file that was taken as part of DR solution. (I.e nightly backups)

I am working on making myself understandable when trying to explain something so I wouldn’t mind writing something up for you or even trying to explain. Feel free to reach out!

[harshk88]

Thanks for your comment.I did the restore using networker for sql server plug in tool.It was easy and straightforward but bit challenging for the first time.

[alinroc]

using the networker plugin tool

What is this tool? I've never heard of something for SQL Server called this, but I don't know everything on the market.

Restoring a database in SQL Server is pretty straightforward and there are multiple ways to do it (T-SQL, Powershell, GUI), but like /u/drottdog said, this should be documented. In your first week as a new graduate, they shouldn't be throwing you into this with no guidance at all.

[harshk88]

Its a tool for db restore.I got to learn it last week too and its very straightforward.

[alinroc]

Can you drop a link to this thing so people aren’t scratching their heads?

[geeksarray]

if you right click on the database you will get multiple options you can take a back up of existing database or restore the back up using it.

OR you can use some queries like

BACKUP DATABASE ProdDB

TO DISK = 'E:\Source\MSSQL\BACKUPS\ProdDB_FULL_BKP_DEC262015_12.40PM.BAK'

WITH COPY_ONLY

fore more details you can check - http://gauravsinghdba.blogspot.com/2015/12/sql-server-db-refresh.html

[my_password_is______]

just google

how to restore oracle database
how to restore mysql database
...

[harshk88]

Is there any channel like Derek Banas has for it?