Blogs tagged SSMS

Overview  Alert appearing in FRUN or CCMS (Tx code RZ20) as shown below,   that Filesystem was full  and used space was 98% in the C: drive in the server host. Login to windows server “<hostname>” . As shown above,... Read More »

  Overview There was an alert in the RZ20 that the filesystem i.e. C: drive was nearly full. Used space was 98% in the C: drive in the MS SQL server host. As shown above, file size for MSDBData.mdf was approaching to 4.2 GB (normally it should... Read More »

For a SQL Server DBA handling multiple databases on any given time, knowing how to set up regular backup schedules, backups with unique names on a daily basis, making backup mirrors for redundancy, cleaning up old backup files is important. Equally... Read More »

These are the following steps you need to follow in order to create a .bak file (backup) using SSMS: To automate and schedule a backup with SQL Server Agent: Open your SQL server Management Studio Log into SQL Server Management Studio (SSMS) and... Read More »

You want to get an alert, or have an approval procedure to be applied when a new marketing document is added to SAP Business One, to get this, we’ll execute the following query as an example; SELECT docnum, cardcode, doctime, createdate FROM... Read More »

Go to SQL Server Management Studio (SSMS), Enter your administrating credentials to connect to the server, Under the Object Explorer > Security > Logins > sa (double click on it) A new pop-up window will appear “Login Properties –... Read More »

Backup – Restore SAP Business One 9.2 Database Using SQL Server Management Studio (SSMS)   During this operation we’ll need to two tools; SAP Business One, to browse, refresh and read the databases’ contains. SQL Server Management... Read More »