If disk space on your SECONDARY side is full and you want to move one of your databasefile to other location. You can manage in 3 steps: ALTER DATABASE LogShipped_DB MODIFY FILE ( NAME = myLogShip, FILENAME = ‘D:\SQLMonitor\LogShip.mdf’ ); With this command, you have indicated that you are going to move datafile to sql […]
You need to add new datafile to your SQL SERVER that has LOGSHIPPING. So automatically same datafile will be created on secondary side. What if drive letter is different on secondary node? To manage you sould run this command on secondary side to tell sql server to create datafile on where you want.
You can list all errors getting from SQL Mail and than perform troubleshooting : select * from sysmail_allitemsorder by sent_date desc