388 reputation
1313
bio website
location
age
visits member for 3 years, 1 month
seen Mar 24 at 21:54

Mar
24
accepted Delayed transactional replication setup?
Mar
24
asked Delayed transactional replication setup?
Mar
3
accepted Database which was set up for logshipping is dropped
Mar
3
comment Database which was set up for logshipping is dropped
There are two jobs: LSAlert_ServerName and LSBackup_DBName. Is it safe manually remove both if there is no logshipping set on the server? Or LSAlert_Server should be kept if there are other logshipping on the server?
Mar
3
comment Database which was set up for logshipping is dropped
Thanks. It seems a couple of jobs were created in the SQL Agent. Should these jobs be removed manually? Or anything else need to be done for removing these jobs?
Mar
2
asked Database which was set up for logshipping is dropped
Feb
24
awarded  Curious
Feb
23
revised Is it good to save tempdb and log files in one drive?
deleted 1 character in body
Feb
23
asked Is it good to save tempdb and log files in one drive?
Feb
2
comment Why the simple insert into query allocated a lot of tempdb?
Actually it used hash join. I guess the tempdb allocation was required by previous SQL in the session. (There were multiple SQL statements in the query window)
Feb
1
comment Why the simple insert into query allocated a lot of tempdb?
@SeanGallardy Yes, it uses merge join. However, considering the small size of the table, why it uses so many tempdb? What's the unit of tempdb_allocations btw?
Feb
1
asked Why the simple insert into query allocated a lot of tempdb?
Jan
29
awarded  Popular Question
Jan
23
accepted Database cannot be opened. It is in the middle of a restore?
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
Thanks. I was trying to check if there is any perfect solution which doesn't have the problem of log shipping killing running query when restoring and can be over FTP.
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
ftp, PowerShell, C#, etc., still need to work with something that tracks the changes in SQL server?
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
Curiously, what's other options (inside or outside of SQL server)? Can merge replication do this?
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
Is it possible to set up mirroring to transfer the changes over FTP (there is no direct TCP connection between the servers). I know log shipping can be configured to send the backup files that way.
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
It seems it may not be a great idea to use log shipping for a secondary reporting server in a production environment.
Jan
23
asked Database cannot be opened. It is in the middle of a restore?