| |

VerySource

 Forgot password?
 Register
Search
View: 620|Reply: 2

How to restore the backup package of mssql space on the Internet?

[Copy link]

3

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-1-7 13:00:01
| Show all posts |Read mode
I bought an mssql space on the Internet. The permissions assigned to the user are db_owner and db_backupoperator. To restore the backup package, you need to stop the database before you can recover, right. How can I stop the remote connection to the space through the Enterprise Manager? Database to restore my backup?
One more question. I bought a database of 300M. Now the logs account for more than 100M. Are these logs useful? If it does n’t work, I ’ll clean it up. Thank you
Reply

Use magic Report

0

Threads

88

Posts

55.00

Credits

Newbie

Rank: 1

Credits
55.00

 China

Post time: 2020-1-7 17:36:01
| Show all posts
Database backup and restore, do n’t stop the database ~~ Use it to connect to your account to remotely backup and restore. The log is to record the operation of the database
Reply

Use magic Report

0

Threads

88

Posts

55.00

Credits

Newbie

Rank: 1

Credits
55.00

 China

Post time: 2020-1-7 17:45:01
| Show all posts
It is not recommended to delete, you can shrink one
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list