MSSQLTips

Hi all, I have a job that uses the utility sqlmaint to create backups for user dbs on one sql server 2005. in case in the corresponding step an error appears, the job is set to go to next step. now - the problem is that after the sqlmaint throws an error, it does not come out immediately - but still...

Hello Sir, Can u get me the answer to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. What...

Hy every one I am using Micrsoft Sql desktop engine installed by an application "epihandy". The databse is created by the application so i have no idea about the rules and policies regarding the access. I have a main server A and a Backup server B where i need to use the database, while not...

Hi My name Kasi viswanadh. I have one query to you i.e. Let me explain site setup. we have one fax server application for that we install SQL express. In sql express dosnt cosist SQL-AGENT service. Can any one guide us what is backup and restore script for sql express and need to place in batch file...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

I have Ms SQLserver 2005 running on windows server 2003 std edition. Help me out taking backup from the server to desktopPC which has windows XP serverpack 2 as an operating system.

donot have even tranaction log backup. if you have transaction log backup then we can recover by apply trans backup to old DB.

By mistake I restore the old database backup on the database and i don't have any latest backup. Is there any way i can rollbacl that restore...

UPDATE: This script requires the Invoke-TryCatch.ps1 and the newly posted Invoke-Nz.ps1 scripts as well - thanks to all who pinged me about the Inovke-Nz.ps1 being required. A while back I posted on Automating a Database Restore and it was quite a popular post, I also received multiple emails with requests...

deal11deal1, Check out this tip: http://www.mssqltips.com/tip.asp?tip=1584 Thank you, The MSSQLTips Team