Date Range
Date Range
Date Range
Musings on Data, Data Management and SQL Server. Friday, 23 October 2015. Always check the basics - backups. Are your databases being backed up? Can you restore from them? SQL Server has a built in way to check when the database was last backed up. Via T-SQL - query the sys. You can identify the last time the database had a full, differential or transaction log backup. You can also use a Policy Based Management. The database was backed up.
How to melt down oxycontin to shoot it.
Friday, March 30, 2012. Table on a 2000 server. Proc runs pulled into it. I selected all tables but when it ran it failed.
Friday, March 30, 2012. Are there any commands that would give infomation on all DBs on a SQL. IE size, location of files, name, that sort of thing? Been given about twenty SQLservers and due to a person leaving I am hoping to. Find ot some information about what is on them.
Friday, March 30, 2012. We have sql server 2000 ,we r dong transactional replication,out distribution. Agent latency is around 1000000 from last 2 days before that,it was around. 4000,please suggest us the solution immediately. Assuming there hasnt been a massive increase in replicated commands, have a. Look for blocking issues on the subscriber when the distribution agent runs. Paul Ibison SQL Server MVP, www.